from sqlalchemy import Column, Integer, String, DateTime, Double, func
from sqlalchemy.orm import declarative_base
from sqlalchemy.types import TypeDecorator, String
from sqlalchemy.sql import operators

class StringLikeComparator(TypeDecorator):
    impl = String

    class comparator_factory(String.Comparator):
        def __eq__(self, other):
            return self.op('LIKE')(f'%{other}%')


Base = declarative_base()


class LC_StockArchives(Base):
    __tablename__ = 'LC_StockArchives'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    State = Column(Integer())
    SecretaryBD = Column(String())
    SecuAffairsRepr = Column(String())
    AuthReprSBD = Column(String())
    ContactTel = Column(String())
    ContactFax = Column(String())
    ContactEmail = Column(String())
    RegAddr = Column(String())
    RegZipCode = Column(String())
    OfficeAddr = Column(String())
    OfficeZipCode = Column(String())
    ContactAddr = Column(String())
    ConatactZipCode = Column(String())
    Email = Column(String())
    Website = Column(String())
    DisclosureWebsites = Column(String())
    DisclosurePapers = Column(String())
    EstablishmentDate = Column(String())
    IRegPlace = Column(String())
    LegalRepr = Column(String())
    GeneralManager = Column(String())
    LegalConsultant = Column(String())
    AccountingFirm = Column(String())
    InduCSRC = Column(Integer())
    BusinessMajor = Column(String())
    BusinessMinor = Column(String())
    AShareAbbr = Column(String())
    AStockCode = Column(String())
    BShareAbbr = Column(String())
    BStockCode = Column(String())
    HShareAbbr = Column(String())
    HStockCode = Column(String())
    BriefIntroText = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    ChiName = Column(String())
    BusinessRegNumber = Column(String())
    SecretaryBDTel = Column(String())
    SecretaryBDFax = Column(String())
    SecretaryBDEmail = Column(String())
    SecuAffairsReprTel = Column(String())
    SecuAffairsReprFax = Column(String())
    SecuAffairsReprEmail = Column(String())
    CityCode = Column(Integer())
    CDRShareAbbr = Column(String())
    CDRStockCode = Column(String())
    ExtendedAbbr = Column(String())
    UnprofitableMark = Column(String())
    SpecialVoteMark = Column(String())
    VIEMark = Column(String())
    RedChipMark = Column(String())
    RegArea = Column(Integer())


class LC_NameChange(Base):
    __tablename__ = 'LC_NameChange'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    SMDeciPublDate = Column(String())
    IfPassed = Column(Integer())
    ChangeDate = Column(String())
    ChiName = Column(String())
    ChiNameAbbr = Column(String())
    EngName = Column(String())
    EngNameAbbr = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())


class LC_Business(Base):
    __tablename__ = 'LC_Business'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    SMDeciPublDate = Column(String())
    IfPassed = Column(String())
    BusinessMajor = Column(String())
    BusinessMinor = Column(String())
    MainBusiness = Column(String())
    MainName = Column(String())
    CSRCInduCategory = Column(Integer())
    InduEngaged = Column(String())
    ChangeReason = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    IndustryType = Column(Integer())


class LC_ExgIndustry(Base):
    __tablename__ = 'LC_ExgIndustry'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    Standard = Column(Integer())
    Industry = Column(Integer())
    IfPerformed = Column(Integer())
    CancelDate = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    FirstIndustryCode = Column(String())
    FirstIndustryName = Column(String())
    SecondIndustryCode = Column(String())
    SecondIndustryName = Column(String())
    ThirdIndustryCode = Column(String())
    ThirdIndustryName = Column(String())
    FourthIndustryCode = Column(String())
    FourthIndustryName = Column(String())
    InsertTime = Column(String())


class LC_ExgIndChange(Base):
    __tablename__ = 'LC_ExgIndChange'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    Standard = Column(Integer())
    Industry = Column(Integer())
    IfExecuted = Column(Integer())
    CancelDate = Column(String())
    FirstIndustryCode = Column(String())
    FirstIndustryName = Column(String())
    SecondIndustryCode = Column(String())
    SecondIndustryName = Column(String())
    ThirdIndustryCode = Column(String())
    ThirdIndustryName = Column(String())
    FourthIndustryCode = Column(String())
    FourthIndustryName = Column(String())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class LC_IndustryValuation(Base):
    __tablename__ = 'LC_IndustryValuation'

    ID = Column(Integer(), primary_key=True, nullable=False)
    IndustryNum = Column(Integer())
    TradingDay = Column(String())
    StatType = Column(Integer())
    SectorCode = Column(Integer())
    Standard = Column(Integer())
    IndustryCode = Column(String())
    TotalMV = Column(Double())
    NegotiableMV = Column(Double())
    FreeFloatMV = Column(Double())
    PE_TTM = Column(Double())
    PE_LYR = Column(Double())
    PB_LF = Column(Double())
    DividendRatio = Column(Double())
    PCF_TTM = Column(Double())
    PCF_LYR = Column(Double())
    PS_TTM = Column(Double())
    PS_LYR = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    IndustryName = Column(String())
    Classification = Column(Integer())
    ListedSecuNum = Column(Integer())


class LC_IndFinIndicators(Base):
    __tablename__ = 'LC_IndFinIndicators'

    ID = Column(Integer(), primary_key=True, nullable=False)
    IndustryNum = Column(Integer())
    IndustryName = Column(String())
    Classification = Column(Integer())
    IndustryCode = Column(String())
    Standard = Column(Integer())
    StatType = Column(Integer())
    SectorCode = Column(Integer())
    InfoPublDate = Column(String())
    EndDate = Column(String())
    DataMark = Column(Integer())
    ListedSecuNum = Column(Integer())
    IndOperatingRevenueTTM = Column(Double())
    IndOperatingRevenue = Column(Double())
    IndOperatingCost = Column(Double())
    IndOperatingProfitTTM = Column(Double())
    IndOperatingProfit = Column(Double())
    IndNetProfitTTM = Column(Double())
    IndNetProfit = Column(Double())
    IndNPCOwnersTTM = Column(Double())
    IndNPParentComOwners = Column(Double())
    IndNetAssets = Column(Double())
    IndTotalAssets = Column(Double())
    IndTotalShares = Column(Double())
    EPSAvg = Column(Double())
    ROEAvg = Column(Double())
    ROE = Column(Double())
    ROETTM = Column(Double())
    WROECut = Column(Double())
    ROECut = Column(Double())
    ROAAvg = Column(Double())
    DilutedROA = Column(Double())
    ROATTM = Column(Double())
    GrossIncomeRatio = Column(Double())
    GrossIncomeRatioTTM = Column(Double())
    NetProfitRatio = Column(Double())
    NetProfitRatioTTM = Column(Double())
    NetProfitRatioCut = Column(Double())
    FinExpenseRateTTM = Column(Double())
    OperatingExpenseRate = Column(Double())
    OperatExpenseRateTTM = Column(Double())
    PeriodCostsRate = Column(Double())
    TOperatingCostToTOR = Column(Double())
    ROIC = Column(Double())
    CurrentRatio = Column(Double())
    QuickRatio = Column(Double())
    InterestCover = Column(Double())
    NOCFInterestCover = Column(Double())
    NPParentCompanyYOY = Column(Double())
    GrossProfitYOY = Column(Double())
    InventoryTRate = Column(Double())
    InventoryTDays = Column(Double())
    ARTRate = Column(Double())
    ARTDays = Column(Double())
    ReceivableTRate = Column(Double())
    TotalAssetTRate = Column(Double())
    NetOperCFToToOperReve = Column(Double())
    DebtAssetsRatio = Column(Double())
    NetTangibleAssetsTA = Column(Double())
    OutInvestOwnersEquity = Column(Double())
    AdvanceReceToTOR = Column(Double())
    AccountReceToTOR = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class LC_COConcept(Base):
    __tablename__ = 'LC_COConcept'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    ConceptCode = Column(Integer())
    InDate = Column(String())
    OutDate = Column(String())
    IndiState = Column(Integer())
    Remark = Column(String())
    InfoPublDate = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class LC_ConceptList(Base):
    __tablename__ = 'LC_ConceptList'

    ID = Column(Integer(), primary_key=True, nullable=False)
    ClassCode = Column(Integer())
    ClassName = Column(String())
    SubclassCode = Column(Integer())
    SubclassName = Column(String())
    ConceptCode = Column(Integer())
    ConceptName = Column(String())
    BeginDate = Column(String())
    EndDate = Column(String())
    ConceptState = Column(Integer())
    Remark = Column(String())
    InfoPublDate = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    ConceptEngName = Column(String())


class LC_SuppCustDetail(Base):
    __tablename__ = 'LC_SuppCustDetail'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InfoPublDate = Column(String())
    CompanyCode = Column(Integer())
    InfoSource = Column(String())
    InfoSourceCode = Column(Integer())
    EndDate = Column(String())
    RelationType = Column(Integer())
    SerialNumber = Column(Integer())
    RelatedPartyName = Column(String())
    RelatedPartyCode = Column(Integer())
    RelatedPartyAttribute = Column(Integer())
    TargetName = Column(String())
    TargetCode = Column(Integer())
    TradingValue = Column(Double())
    Ratio = Column(Double())
    Remark = Column(String())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class LC_SHTypeClassifi(Base):
    __tablename__ = 'LC_SHTypeClassifi'

    ID = Column(Integer(), primary_key=True, nullable=False)
    SHID = Column(Integer())
    SHCode = Column(String())
    SHName = Column(String())
    SHAttribute = Column(Integer())
    Standard = Column(Integer())
    FirstLvCode = Column(Integer())
    SecondLvCode = Column(Integer())
    ThirdLvCode = Column(Integer())
    FourthLvCode = Column(Integer())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class LC_MainSHListNew(Base):
    __tablename__ = 'LC_MainSHListNew'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    InfoTypeCode = Column(Integer())
    SHNo = Column(Integer())
    SHSerial = Column(Integer())
    SHList = Column(String())
    SHKind = Column(String())
    SHTypeCode = Column(Integer())
    SHType = Column(String())
    SecuCoBelongedCode = Column(Integer())
    SecuCoBelongedName = Column(String())
    SecuCode = Column(String())
    SecuAbbr = Column(String())
    HoldSum = Column(Double())
    PCTOfTotalShares = Column(Double())
    RestrainedTShare = Column(Double())
    UnstintedTShare = Column(Double())
    HoldSumChange = Column(Double())
    HoldSumChangeRate = Column(Double())
    HoldAShareSum = Column(Double())
    PCTOfFloatShares = Column(Double())
    HoldBShareSum = Column(Double())
    HoldHShareSum = Column(Double())
    HoldOthterShareSum = Column(Double())
    ShareCharacterStatement = Column(String())
    PledgeInvolvedSum = Column(Double())
    FreezeInvolvedSum = Column(Double())
    PFStatement = Column(String())
    ConnectionRelation = Column(String())
    ConnectionStatement = Column(String())
    ActInConcertStatement = Column(String())
    Notes = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    SecuInnerCode = Column(Integer())
    SHKindCode = Column(Integer())
    GDID = Column(Integer())
    SHAttribute = Column(Integer())
    RestrainedAShare = Column(Double())
    UnstintedAShare = Column(Double())
    HoldShareASum = Column(Double())
    RestrainedShareA = Column(Double())
    UnstintedShareA = Column(Double())
    HoldShareBSum = Column(Double())
    RestrainedShareB = Column(Double())
    UnstintedShareB = Column(Double())
    HoldShareCSum = Column(Double())
    HoldShareDSum = Column(Double())
    HoldOtherComShareSum = Column(Double())
    InsertTime = Column(String())
    HoldChangeType = Column(Integer())
    PrefShareWithVotRight = Column(Double())
    VotingRightsVol = Column(Double())
    VotingRightsRatio = Column(Double())
    SpecialVotingRightsVol = Column(Double())
    PCTOfNRShares = Column(Double())
    RefinanceLoanShare = Column(Double())


class LC_SHNumber(Base):
    __tablename__ = 'LC_SHNumber'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    EndDate = Column(String())
    SHNum = Column(Integer())
    AverageHoldSum = Column(Double())
    ASHNum = Column(Integer())
    AAverageHoldSum = Column(Double())
    BSHNum = Column(Integer())
    BAverageHoldSum = Column(Double())
    HSHNum = Column(Integer())
    HAverageHoldSum = Column(Double())
    StaffSHNum = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    HoldProportionPAccount = Column(Double())
    ProportionChange = Column(Double())
    AvgHoldSumGRQuarter = Column(Double())
    ProportionGRQuarter = Column(Double())
    AvgHoldSumGRHalfAYear = Column(Double())
    ProportionGRHalfAYear = Column(Double())
    AHoldProportionPAccount = Column(Double())
    AProportionChange = Column(Double())
    AAvgHoldSumGRQuarter = Column(Double())
    AProportionGRQuarter = Column(Double())
    AAvgHoldSumGRHalfAYear = Column(Double())
    AProportionGRHalfAYear = Column(Double())
    AFAverageHoldSum = Column(Integer())
    AFHoldProportionPAccount = Column(Double())
    AFProportionChange = Column(Double())
    AFAvgHoldSumGRQuarter = Column(Double())
    AFProportionGRQuarter = Column(Double())
    AFAvgHoldSumGRHalfAYear = Column(Double())
    AFProportionGRHalfAYear = Column(Double())
    BHoldProportionPAccount = Column(Double())
    BProportionChange = Column(Double())
    BAvgHoldSumGRQuarter = Column(Double())
    BProportionGRQuarter = Column(Double())
    BAvgHoldSumGRHalfAYear = Column(Double())
    BProportionGRHalfAYear = Column(Double())
    HHoldProportionPAccount = Column(Double())
    HProportionChange = Column(Double())
    HAvgHoldSumGRQuarter = Column(Double())
    HProportionGRQuarter = Column(Double())
    HAvgHoldSumGRHalfAYear = Column(Double())
    HProportionGRHalfAYear = Column(Double())
    AFHoldPropTA = Column(Integer())
    CDRSHNum = Column(Integer())
    CDRAverageHoldSum = Column(Double())
    CDRHoldPropPAccount = Column(Double())
    CDRProportionChange = Column(Double())
    CDRAvgHoldSumGRQtr = Column(Double())
    CDRPropGRQuarter = Column(Double())
    CDRAvgHoldSumGRHalfAY = Column(Double())
    CDRPropGRHalfAYear = Column(Double())
    CDRFAverageHoldSum = Column(Integer())
    CDRFHoldPropPAccount = Column(Double())
    CDRFProportionChange = Column(Double())
    CDRFAvgHoldSumGRQtr = Column(Double())
    CDRFPropGRQuarter = Column(Double())
    CDRFAvgHoldSumGRHalfAY = Column(Double())
    CDRFPropGRHalfAYear = Column(Double())
    NumApproxiMark = Column(Integer())


class LC_Mshareholder(Base):
    __tablename__ = 'LC_Mshareholder'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    MSHName = Column(String())
    MSHPercentage = Column(Double())
    MSHNumber = Column(Integer())
    GetMethod = Column(Integer())
    LegalRepr = Column(String())
    RegCapital = Column(Double())
    MainBusiness = Column(String())
    EconomicNature = Column(Integer())
    BackgroundIntr = Column(String())
    IfExisted = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    BulletinType = Column(Integer())
    NationalityDesc = Column(String())
    PermanentResidency = Column(String())
    StructureChart = Column(String())
    FileType = Column(Integer())
    EndDate = Column(String())
    SHAttribute = Column(Integer())
    CurrencyUnit = Column(Integer())
    GDID = Column(Integer())


class LC_ActualController(Base):
    __tablename__ = 'LC_ActualController'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    EndDate = Column(String())
    ControllerCode = Column(Integer())
    ControllerName = Column(String())
    EconomicNature = Column(Integer())
    NationalityCode = Column(Integer())
    NationalityDesc = Column(String())
    PermanentResidency = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    ControllerNature = Column(Integer())


class LC_ShareStru(Base):
    __tablename__ = 'LC_ShareStru'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoSource = Column(String())
    EndDate = Column(String())
    NonListedShares = Column(Double())
    PromoterShares = Column(Double())
    StateShares = Column(Double())
    DLegalPersonShares = Column(Double())
    FLegalPersonShares = Column(Double())
    OtherPromoterShares = Column(Double())
    RaisedLPShares = Column(Double())
    NaturalPersonHoldLPShares = Column(Double())
    StaffShares = Column(Double())
    RightsIssueTransferred = Column(Double())
    PreferredAndOtherShares = Column(Double())
    PreferredShares = Column(Double())
    FloatShare = Column(Double())
    AFloats = Column(Double())
    AFloatListed = Column(Double())
    ManagementShares = Column(Double())
    StategicInvestorShares = Column(Double())
    CommonLPShares = Column(Double())
    MutualFundShares = Column(Double())
    AdditionalIssueUnlisted = Column(Double())
    RightsIssueUnlisted = Column(Double())
    Bshares = Column(Double())
    Hshares = Column(Double())
    Sshares = Column(Double())
    Nshares = Column(Double())
    OtherFloatShares = Column(Double())
    TotalShares = Column(Double())
    ChangeType = Column(Integer())
    ChangeReason = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    SLegalPersonShares = Column(Double())
    RaisedSLPShares = Column(Double())
    OtherAFloatShares = Column(Double())
    RestrictedAFloatShares = Column(Double())
    RestrinctStaffShares = Column(Double())
    NonListedBShares = Column(Double())
    InfoPublDate = Column(String())
    RestrictedShares = Column(Double())
    StateHolding = Column(Double())
    SLegalPersonHolding = Column(Double())
    OtherDCapitalHolding = Column(Double())
    DLegalPersonHolding = Column(Double())
    DNaturalPersonHolding = Column(Double())
    ForeignHolding = Column(Double())
    FLegalPersonHolding = Column(Double())
    FNaturalPersonHolding = Column(Double())
    OtherRestrictedShares = Column(Double())
    RestrictedBFloatShares = Column(Double())
    PerValue = Column(Double())
    Ashares = Column(Double())
    NonRestrictedShares = Column(Double())
    BsharesTotal = Column(Double())
    ListedBShares = Column(Double())
    NonListedRestrictedBShares = Column(Double())
    ForeignHoldingAshares = Column(Double())
    RestrictedAShares = Column(Double())
    OtherFNonListedShares = Column(Double())
    NonResiSharesJY = Column(Double())
    RestrictAShareP = Column(Double())
    SRUnlistedShare = Column(Double())
    NonResiBShares = Column(Double())
    GDRshares = Column(Double())
    ParValueCurrencyUnit = Column(Integer())
    InsertTime = Column(String())
    NonRestrictedHShares = Column(Double())
    RestrictedHShares = Column(Double())
    OUnListedShares = Column(Double())
    OtherNonListedShares = Column(Double())
    Dshares = Column(Double())


class LC_StockHoldingSt(Base):
    __tablename__ = 'LC_StockHoldingSt'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    InfoSource = Column(String())
    InstitutionsHoldings = Column(Double())
    FundsHoldings = Column(Double())
    SecuritiesCorpsHoldings = Column(Double())
    FinancingProductsHoldings = Column(Double())
    QFIIHoldings = Column(Double())
    InsuranceCorpsHoldings = Column(Double())
    SocialSecurityFundHold = Column(Double())
    EnterpriseAnnuitiesHold = Column(Double())
    TrustCompaniesHoldings = Column(Double())
    FinanceCompaniesHoldings = Column(Double())
    OtherInstitutionHoldings = Column(Double())
    InstitutionsHoldProp = Column(Double())
    FundsHoldProp = Column(Double())
    SecuritiesCorpsHoldProp = Column(Double())
    FinancingProductsHoldProp = Column(Double())
    QFIIHoldProp = Column(Double())
    InsuranceCorpsHoldProp = Column(Double())
    SocialSecuFundHoldProp = Column(Double())
    CorpAnnuitiesHoldProp = Column(Double())
    TrustCompaniesHoldProp = Column(Double())
    FinanceCompaniesHoldProp = Column(Double())
    OtherInstitutionHoldProp = Column(Double())
    InstitutionsHoldingsA = Column(Double())
    FundsHoldingsA = Column(Double())
    SecuritiesCorpsHoldingsA = Column(Double())
    FinanceProductsHoldingsA = Column(Double())
    QFIIHoldingsA = Column(Double())
    InsuranceCorpsHoldingsA = Column(Double())
    SocialSecurityFundHoldA = Column(Double())
    EnterpriseAnnuitiesHoldA = Column(Double())
    TrustCompaniesHoldingsA = Column(Double())
    FinanceCompHoldingsA = Column(Double())
    OtherInstiHoldingsA = Column(Double())
    InstitutionsHoldPropA = Column(Double())
    FundsHoldPropA = Column(Double())
    SecuritiesCorpsHoldPropA = Column(Double())
    FinanceProductsHoldPropA = Column(Double())
    QFIIHoldPropA = Column(Double())
    InsuranceCorpsHoldPropA = Column(Double())
    SocialSecuFundHoldPropA = Column(Double())
    CorpAnnuitiesHoldPropA = Column(Double())
    TrustCompaniesHoldPropA = Column(Double())
    FinanceCompHoldPropA = Column(Double())
    OtherInstiHoldPropA = Column(Double())
    InstitutionsHoldingsT = Column(Double())
    FundsHoldingsT = Column(Double())
    SecuritiesCorpsHoldingsT = Column(Double())
    FinanceProductsHoldingsT = Column(Double())
    QFIIHoldingsT = Column(Double())
    InsuranceCorpsHoldingsT = Column(Double())
    SocialSecurityFundHoldT = Column(Double())
    EnterpriseAnnuitiesHoldT = Column(Double())
    TrustCompaniesHoldingsT = Column(Double())
    FinanceCompHoldingsT = Column(Double())
    OtherInstiHoldingsT = Column(Double())
    InstitutionsHoldPropT = Column(Double())
    FundsHoldPropT = Column(Double())
    SecuritiesCorpsHoldPropT = Column(Double())
    FinanceProductsHoldPropT = Column(Double())
    QFIIHoldPropT = Column(Double())
    InsuranceCorpsHoldPropT = Column(Double())
    SocialSecuFundHoldPropT = Column(Double())
    CorpAnnuitiesHoldPropT = Column(Double())
    TrustCompaniesHoldPropT = Column(Double())
    FinanceCompHoldPropT = Column(Double())
    OtherInstiHoldPropT = Column(Double())
    Top10StockholdersAmount = Column(Double())
    Top10StockholdersProp = Column(Double())
    Top10NRStockholdersAmount = Column(Double())
    Top10NRHoldersAmountToNRS = Column(Double())
    Top10NRHoldersAmountToTS = Column(Double())
    NRAFromTop10NRHolders = Column(Double())
    NRAFromTop10ToNRA = Column(Double())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    InstiHoldTNum = Column(Integer())
    InstiHoldANum = Column(Integer())
    InstiHoldNum = Column(Integer())
    FundsHoldingsTNum = Column(Integer())
    SecuCorpsHoldTNum = Column(Integer())
    SecuCorpsHoldANum = Column(Integer())
    SecuCorpsHoldNum = Column(Integer())
    FinProductsHoldTNum = Column(Integer())
    FinProductsHoldANum = Column(Integer())
    FinProductsHoldNum = Column(Integer())
    QFIIHoldTNumber = Column(Integer())
    QFIIHoldANum = Column(Integer())
    QFIIHoldingsNum = Column(Integer())
    InsurCorpsHoldTNum = Column(Integer())
    InsurCorpsHoldANum = Column(Integer())
    InsurCorpsHoldNum = Column(Integer())
    SocialSecuFundHoldTN = Column(Integer())
    SocialSecuFundHoldAN = Column(Integer())
    SocialSecuFundHoldN = Column(Integer())
    EntAnnuitiesHoldTNum = Column(Integer())
    EntAnnuitiesHoldANum = Column(Integer())
    EntAnnuitiesHoldNum = Column(Integer())
    TrustCoHoldTNum = Column(Integer())
    TrustCoHoldANum = Column(Integer())
    TrustCoHoldNum = Column(Integer())
    FinanceCoHoldTNum = Column(Integer())
    FinanceCoHoldANum = Column(Integer())
    FinanceCoHoldNum = Column(Integer())
    OtherInstiHoldTNum = Column(Integer())
    OtherInstiHoldANum = Column(Integer())
    OtherInstiHoldNum = Column(Integer())
    InsertTime = Column(String())
    StatDate = Column(String())
    PrivFundHoldings = Column(Double())
    BankHoldings = Column(Double())
    ForeignInstHoldings = Column(Double())
    PrivFundHoldProp = Column(Double())
    BankHoldProp = Column(Double())
    ForeignInstHoldProp = Column(Double())
    PrivFundHoldNum = Column(Integer())
    BankHoldNum = Column(Integer())
    ForeignInstHoldNum = Column(Integer())
    PrivFundHoldingsA = Column(Double())
    BankHoldingsA = Column(Double())
    ForeignInstHoldingsA = Column(Double())
    PrivFundHoldPropA = Column(Double())
    BankHoldPropA = Column(Double())
    ForeignInstHoldPropA = Column(Double())
    FundsHoldingsANum = Column(Integer())
    PrivFundHoldANum = Column(Integer())
    BankHoldANum = Column(Integer())
    ForeignInstHoldANum = Column(Integer())
    PrivFundHoldingsT = Column(Double())
    BankHoldingsT = Column(Double())
    ForeignInstHoldingsT = Column(Double())
    PrivFundHoldPropT = Column(Double())
    BankHoldPropT = Column(Double())
    ForeignInstHoldPropT = Column(Double())
    PrivFundHoldTNum = Column(Integer())
    BankHoldTNum = Column(Integer())
    ForeignInstHoldTNum = Column(Integer())


class LC_ShareTransfer(Base):
    __tablename__ = 'LC_ShareTransfer'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    ContractSignDate = Column(String())
    ApprovedDate = Column(String())
    TranDate = Column(String())
    TransfererName = Column(String())
    TansfererEcoNature = Column(Integer())
    TranShareType = Column(Integer())
    SumBeforeTran = Column(Double())
    PCTBeforeTran = Column(Double())
    SumAfterTran = Column(Double())
    PCTAfterTran = Column(Double())
    ReceiverName = Column(String())
    ReceiverEcoNature = Column(Integer())
    SumAfterRece = Column(Double())
    PCTAfterRece = Column(Double())
    TranMode = Column(Integer())
    InvolvedSum = Column(Double())
    PCTOfTansferer = Column(Double())
    PCTOfTotalShares = Column(Double())
    DealPrice = Column(Double())
    DealTurnover = Column(Double())
    ValidCondition = Column(String())
    TranStatement = Column(String())
    IfSuspended = Column(Integer())
    SuspendedPublDate = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    SNBeforeTran = Column(Integer())
    SNAfterTran = Column(Integer())
    SNAfterRece = Column(Integer())
    IfSPBlockTradeCode = Column(Integer())
    IfSPBlockTrade = Column(String())
    InnerCode = Column(Integer())
    ResSumAfterTran = Column(Double())
    NonResSumAfterTran = Column(Double())
    ResSumAfterRece = Column(Double())
    NonResSumAfterRece = Column(Double())
    InitialInfoPublDate = Column(String())
    TransfererAttribute = Column(Integer())
    TransfererCode = Column(Integer())
    ReceiverAttribute = Column(Integer())
    ReceiverCode = Column(Integer())
    InsertTime = Column(String())
    SumBeforeRece = Column(Double())
    PCTBeforerRece = Column(Double())
    TranStartDate = Column(String())
    SerialNumber = Column(Integer())


class LC_ShareFP(Base):
    __tablename__ = 'LC_ShareFP'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    TypeSelect = Column(Integer())
    FPSHName = Column(String())
    ReceiverName = Column(String())
    InvolvedSum = Column(Double())
    PCTOfPledger = Column(Double())
    PCTOfTotalShares = Column(Double())
    FPReason = Column(String())
    StartDate = Column(String())
    EndDate = Column(String())
    Statement = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    SHSN = Column(Integer())
    SHAttribute = Column(Integer())
    SHID = Column(Integer())
    ReceiverAttribute = Column(Integer())
    ReceiverID = Column(Integer())
    EventCode = Column(String())
    EventDate = Column(String())
    UnstintedTShare = Column(Integer())
    RestrainedTShare = Column(Integer())
    InitialInfoPublDate = Column(String())
    InitialPledgeSum = Column(Double())
    EstimateReleaseDate = Column(String())


class LC_ShareFPSta(Base):
    __tablename__ = 'LC_ShareFPSta'

    ID = Column(Integer(), primary_key=True, nullable=False)
    FPCode = Column(Integer())
    EndDate = Column(String())
    InfoSource = Column(String())
    Category = Column(Integer())
    CompanyCode = Column(Integer())
    FPSHName = Column(String())
    AccuFPShares = Column(Double())
    AccuPCTOfPled = Column(Double())
    AccuProportion = Column(Double())
    UpdateTime = Column(String())
    AccuProportionCalc = Column(Double())
    SHAttribute = Column(Integer())
    SHID = Column(Integer())
    JSID = Column(Integer())
    AccuFPSharesCalc = Column(Double())


class LC_Buyback(Base):
    __tablename__ = 'LC_Buyback'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    FirstPublDate = Column(String())
    InfoSource = Column(String())
    ShareType = Column(Integer())
    AdvanceDate = Column(String())
    MeetPassDate = Column(String())
    WriteOffPublDate = Column(String())
    ContractDate = Column(String())
    Seller = Column(String())
    BuybackSum = Column(Double())
    Percentage = Column(Double())
    PricingStatement = Column(String())
    BuybackPrice = Column(Double())
    BuybackMoney = Column(Double())
    StartDate = Column(String())
    EndDate = Column(String())
    PayMode = Column(Integer())
    ChangeDate = Column(String())
    PayDate = Column(String())
    ChangeRegDate = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    VolumeFloor = Column(Double())
    VolumeCeiling = Column(Double())
    PriceFloor = Column(Double())
    PriceCeiling = Column(Double())
    ValueFloor = Column(Double())
    ValueCeiling = Column(Double())
    MaturityDesc = Column(String())
    EventProcedure = Column(Integer())
    EventProceDesc = Column(String())
    BuybackModeCode = Column(Integer())
    BuybackModeDesc = Column(String())
    FundsSourceDesc = Column(String())
    PurposeDesc = Column(String())
    InsertTime = Column(String())
    BuybackPurpose = Column(Integer())
    CurrencyUnit = Column(Integer())
    OverruledDate = Column(String())


class LC_BuybackAttach(Base):
    __tablename__ = 'LC_BuybackAttach'

    ID = Column(Integer(), primary_key=True, nullable=False)
    BuybackID = Column(Integer())
    InfoPublDate = Column(String())
    EffectiveDate = Column(String())
    CurrencyUnit = Column(Integer())
    BuybackSum = Column(Double())
    Percentage = Column(Double())
    CumulativeSum = Column(Double())
    CumulativeSumToTS = Column(Double())
    HighPrice = Column(Double())
    LowPrice = Column(Double())
    BuybackFunds = Column(Double())
    CumulativeValueSum = Column(Double())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    InsertTime = Column(String())


class LC_LegalDistribution(Base):
    __tablename__ = 'LC_LegalDistribution'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    DistributionSum = Column(Double())
    DistributionReason = Column(Integer())
    SerialNum = Column(Integer())
    AquirerName = Column(String())
    AquirerCharacter = Column(Integer())
    SecuCoBelongedCode = Column(Integer())
    SecuCoBelonged = Column(String())
    SecuCode = Column(Integer())
    AquiredSum = Column(Double())
    OwnedPeriod = Column(Integer())
    DistributeNature = Column(Integer())
    FloatDate = Column(String())
    Notes = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    IssuePrice = Column(Double())
    ValidApplyVol = Column(Double())
    RefundAmount = Column(Double())
    InitialInfoPublDate = Column(String())
    SecuAccountNumber = Column(String())
    SupplementAmount = Column(Double())
    RestrictedSum = Column(Double())
    NonRestrictedSum = Column(Double())
    InvestorName = Column(String())
    InvestorType = Column(Integer())
    InvestorCode = Column(Integer())
    InsertTime = Column(String())
    CoreStaffsStraSHVal = Column(Double())
    SponsorStraSharesHVal = Column(Double())
    OtherStraSHVol = Column(Double())
    OtherStraSHVal = Column(Double())
    OtherStraSHRat = Column(Double())
    BidderCode = Column(String())
    AquirerAmount = Column(Double())
    StandardInvestorName = Column(String())
    StandardAquirerName = Column(String())
    AquirerType = Column(Integer())
    ClassofInvestor = Column(Integer())


class LC_NationalStockHoldSt(Base):
    __tablename__ = 'LC_NationalStockHoldSt'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    SHID = Column(Integer())
    SHName = Column(String())
    HoldAShareSum = Column(Double())
    RestrainedAShare = Column(Double())
    UnstintedAShare = Column(Double())
    PCTOfTotalShares = Column(Double())
    PCTOfFloatShares = Column(Double())
    HoldASumChange = Column(Double())
    HoldASumChangeRate = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class CS_ForeignHoldingSt(Base):
    __tablename__ = 'CS_ForeignHoldingSt'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    TradingDay = Column(String())
    ForeignHoldings = Column(Double())
    ForeignHoldProp = Column(Double())
    UpdateTime = Column(String())
    InsertTime = Column(String())
    JSID = Column(Integer())


class LC_AShareSeasonedNewIssue(Base):
    __tablename__ = 'LC_AShareSeasonedNewIssue'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    AdvanceDate = Column(String())
    SMDeciPublDate = Column(String())
    AdvanceValidStartDate = Column(String())
    AdvanceValidEndDate = Column(String())
    IntentLetterPublDate = Column(String())
    ProspectusPublDate = Column(String())
    StockType = Column(Integer())
    PriceIntervalStatement = Column(String())
    PricingModel = Column(Integer())
    RationModel = Column(Integer())
    IssueMethod = Column(Integer())
    IssueObject = Column(String())
    IssuePriceCeiling = Column(Double())
    IssuePriceFloor = Column(Double())
    ReferringPrice = Column(Double())
    IssueVolCeiling = Column(Double())
    IssueVolFloor = Column(Double())
    OverAllotmentOption = Column(Double())
    IssueStartDate = Column(String())
    IssueEndDate = Column(String())
    UnderwritingStartDate = Column(String())
    UnderwritingEndDate = Column(String())
    IfExRightAShare = Column(Integer())
    RightRegDate = Column(String())
    ExRightDate = Column(String())
    SuspendStartDate = Column(String())
    SuspendEndDate = Column(String())
    PrefPlaDateH = Column(String())
    PrefPlaRatioH = Column(Double())
    PrefPlaApplyCodeH = Column(String())
    PrefPlaApplyAbbrNameH = Column(String())
    IssueDateOnline = Column(String())
    ApplyCodeOnline = Column(String())
    ApplyAbbrNameOnline = Column(String())
    ApplyUnitOnline = Column(Integer())
    ApplyMaxOnline = Column(Double())
    ApplyStartDateLPOffline = Column(String())
    ApplyEndDateLPOffline = Column(String())
    PayStartDateLPOffline = Column(String())
    PlaPayEndDateLPOffline = Column(String())
    ApplyUnitLPOffline = Column(Integer())
    ApplyMinLPOffline = Column(Integer())
    ApplyMaxLPOffline = Column(Double())
    ValidApplyTimesLPOffline = Column(Integer())
    ApplyStartDateF = Column(String())
    ApplyEndDateF = Column(String())
    PayStartDateF = Column(String())
    PayEndDateF = Column(String())
    PrefAllotmentF = Column(Double())
    PrefAllotmentSingleF = Column(Double())
    STAQNETPlaStartDate = Column(String())
    STAQNETPlaEndDate = Column(String())
    STAQNETPlaRatio = Column(Double())
    QuotationUnitOnline = Column(Double())
    QuotationUnitOffline = Column(Double())
    OddLotsTreatment = Column(String())
    ParValue = Column(Double())
    IssuePrice = Column(Double())
    StateSharesIssuePrice = Column(Double())
    WeightedPERatio = Column(Double())
    DilutedPERatio = Column(Double())
    IssueVol = Column(Double())
    StateSharesIssued = Column(Double())
    TotalIssueMV = Column(Double())
    IssueCost = Column(Double())
    UnderwritingFee = Column(Double())
    CPAFee = Column(Double())
    AssetAppraisalFee = Column(Double())
    LandEvaluationFee = Column(Double())
    AttorneyFee = Column(Double())
    TotalAgentFee = Column(Double())
    OnlineIssueFee = Column(Double())
    ScripFee = Column(Double())
    SponsorFee = Column(Double())
    OtherFee = Column(Double())
    IssueCostPerShare = Column(Double())
    FreezedMoney = Column(Double())
    SNIProceeds = Column(Double())
    SNINetProceeds = Column(Double())
    StateSharesProceeds = Column(Double())
    StateSharesNetProceeds = Column(Double())
    MoneyToAccount = Column(Double())
    DateToAccount = Column(String())
    NewShareListDate = Column(String())
    OutstandingShares = Column(Double())
    PutBackVol = Column(Double())
    PrefPlaVolH = Column(Double())
    PublicOfferVolOnline = Column(Double())
    ValidApplyVolOnline = Column(Double())
    ValidApplyNumOnline = Column(Integer())
    OverSubsTimesOnline = Column(Double())
    LotRateOnline = Column(Double())
    PlaVolLPOffline = Column(Double())
    ValidApplyVolLPOffline = Column(Double())
    ValidApplyNumLPOffline = Column(Integer())
    OverSubsTimesLPOffline = Column(Double())
    LotRateLPOffline = Column(Double())
    PlaVolF = Column(Double())
    PlaVolSTAQNET = Column(Double())
    TailoredPlaVolLP = Column(Double())
    EarningForecastYear = Column(String())
    MainIncomeForecast = Column(Double())
    NetProfitForecast = Column(Double())
    DilutedEPSForecast = Column(Double())
    UnderwritingMode = Column(Integer())
    UnderwriterBoughtVol = Column(Double())
    ChangeStatement = Column(String())
    ChangeType = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    PERatioBeforeIssue = Column(Double())
    PERatioAfterIssue = Column(Double())
    PrefPlaVolHMax = Column(Double())
    PrefPlaVolHOnline = Column(Double())
    PrefPlaVolHOffline = Column(Double())
    ValidApplyHNum = Column(Integer())
    ValidApplyNumHOnline = Column(Integer())
    ValidApplyNumHOffline = Column(Integer())
    APlaVolLPOffline = Column(Double())
    AValidApplyVolLPOffline = Column(Double())
    AValidApplyNumLPOffline = Column(Integer())
    ALotRateLPOffline = Column(Double())
    BPlaVolLPOffline = Column(Double())
    BValidApplyVolLPOffline = Column(Double())
    BValidApplyNumLPOffline = Column(Double())
    BLotRateLPOffline = Column(Double())
    PlaVolHOffline = Column(Double())
    ValidPlaVolHOffline = Column(Double())
    ValidPlaNumHOffline = Column(Integer())
    LotRateHOffline = Column(Double())
    SASACApprovalPublDate = Column(String())
    CSRCApprovalPublDate = Column(String())
    EventProcedureCode = Column(Integer())
    ISOBTypeCode = Column(Integer())
    AdjustedIssuePrice = Column(Double())
    PriceAdjustedDate = Column(String())
    SchemeChangePublDate = Column(String())
    ListAnnounceDate = Column(String())
    ProjInfoSource = Column(String())
    IssueResultInfoSource = Column(String())
    AdjustedIssueVol = Column(Double())
    PriceVolAdjustedDate = Column(String())
    IssuePurpose = Column(String())
    PricingBaseDate = Column(String())
    PricingBaseDateDesc = Column(String())
    IssueType = Column(Integer())
    IfEffected = Column(Integer())
    SubscribeMethod = Column(Integer())
    LargeSHSubMethod = Column(Integer())
    LargeSHSubsSum = Column(Double())
    LargeSHSubsRatio = Column(Double())
    PlannedProceeds = Column(Double())
    CurrencyProceeds = Column(Double())
    NonCurrencyProceeds = Column(Double())
    AssetProceeds = Column(Double())
    DebtProceeds = Column(Double())
    UWSponFee = Column(Double())
    CPAAppraisalFee = Column(Double())
    ParValueCurrencyUnit = Column(Integer())
    AdjustedVolFloor = Column(Double())
    AdjustedPriceCeiling = Column(Double())
    DiscountRatePerShare = Column(Double())
    SubscriptionOfferDate = Column(String())
    OrgPriceBasePRatio = Column(Double())
    ActPriceBasePRatio = Column(Double())
    AddSubscriptionSDate = Column(String())
    AddSubscriptionEDate = Column(String())
    VerificationDate = Column(String())
    LatestAdvanceDate = Column(String())
    IfSummaryProcedure = Column(Integer())
    InsertTime = Column(String())


class LC_ASharePlacement(Base):
    __tablename__ = 'LC_ASharePlacement'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    PlaYear = Column(String())
    StockType = Column(Integer())
    AdvanceDate = Column(String())
    SMDeciPublDate = Column(String())
    PricingModel = Column(Integer())
    PricingDescription = Column(String())
    AdvanceValidStartDate = Column(String())
    AdvanceValidEndDate = Column(String())
    PlaRatioPlanned = Column(Double())
    PlaPriceCeiling = Column(Double())
    PlaPriceFloor = Column(Double())
    DeciPublDate = Column(String())
    PlaProspectusPublDate = Column(String())
    PlaAbbrName = Column(String())
    PlaCode = Column(String())
    BaseShares = Column(Double())
    PlannedPlaVol = Column(Double())
    ActualPlaRatio = Column(Double())
    ActualPlaVol = Column(Double())
    PlaObject = Column(String())
    ParValue = Column(Double())
    PlaPrice = Column(Double())
    TransferPlaRatio = Column(Double())
    TransferPlaVol = Column(Double())
    TransferFeePerShare = Column(Double())
    OddLotsTreatment = Column(Integer())
    PlaProceeds = Column(Double())
    PlaCost = Column(Double())
    UnderwritingFee = Column(Double())
    CPAFee = Column(Double())
    AssetAppraisalFee = Column(Double())
    LandEvaluationFee = Column(Double())
    AttorneyFee = Column(Double())
    TotalAgentFee = Column(Double())
    OnlineIssueFee = Column(Double())
    ScripFee = Column(Double())
    SponsorFee = Column(Double())
    OtherFee = Column(Double())
    PlaNetProceeds = Column(Double())
    RightRegDate = Column(String())
    ExRightDate = Column(String())
    PayStartDate = Column(String())
    PayEndDate = Column(String())
    DateToAccount = Column(String())
    MoneyToAccount = Column(Double())
    PlaListDate = Column(String())
    LargeSHSubsStatement = Column(String())
    SchemeChange = Column(Integer())
    ChangeStatement = Column(String())
    UnderwritingMode = Column(Integer())
    UnderwriterBoughtVol = Column(Double())
    PublicSHSubscriptionEsti = Column(Double())
    PublicSHSubscriptionActu = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())
    PlannedPlaProceeds = Column(Double())
    AdjustedPlaRatioPl = Column(Double())
    AdjustedPlaVolPl = Column(Double())
    UWSponFee = Column(Double())
    CPAAppraisalFee = Column(Double())
    CSRCIACApprovalDate = Column(String())
    SASACApprovalPublDate = Column(String())
    CSRCApprovalPublDate = Column(String())
    ExApprovalPublDate = Column(String())
    IssueMethod = Column(Integer())
    EventProcedureCode = Column(Integer())
    LatestInfoPublDate = Column(String())
    PlaProspectus = Column(String())
    ResultPulbDate = Column(String())
    ListAnnounceDate = Column(String())
    PlannedBaseShares = Column(Double())
    PlaObjectCategory = Column(Integer())
    PlaBaseDate = Column(String())
    LargeSHHoldSum = Column(Double())
    LargeSHSubscripEsti = Column(Double())
    LargeSHSubscripActu = Column(Double())
    NAPSAfterAllotment = Column(Double())
    EPSAfterAllotment = Column(Double())
    InsertTime = Column(String())


class LC_Dividend(Base):
    __tablename__ = 'LC_Dividend'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    EndDate = Column(String())
    IfDividend = Column(Integer())
    AdvanceDate = Column(String())
    SMDeciPublDate = Column(String())
    EPS = Column(Double())
    BonusShareRatio = Column(Double())
    TranAddShareRaio = Column(Double())
    PriceUnit = Column(Integer())
    CashDiviRMB = Column(Double())
    ActualCashDiviRMB = Column(Double())
    CashDiviFC = Column(Double())
    ActualCashDiviFC = Column(Double())
    RightRegDate = Column(String())
    ExDiviDate = Column(String())
    BonusShareListDate = Column(String())
    ToAccountDate = Column(String())
    FinalTradingDay = Column(String())
    DiviBase = Column(Double())
    SharesAfterDivi = Column(Double())
    DiviObject = Column(Integer())
    TotalCashDiviComRMB = Column(Double())
    TotalCashDiviComFC = Column(Double())
    CashDiviAShare = Column(Double())
    CashDiviBShareRMB = Column(Double())
    CashDiviBShareFC = Column(Double())
    DiviStartDate = Column(String())
    IFSchemeChange = Column(Integer())
    ChangeStatement = Column(String())
    ChangeType = Column(Integer())
    IfDiviBeforeChange = Column(Integer())
    BonusShareRatioBeforeChange = Column(Double())
    TranAddShareRatioBeforeChange = Column(Double())
    CashDiviBeforeChangeRMB = Column(Double())
    CashDiviBeforeChangeFC = Column(Double())
    DiviBaseBeforeChange = Column(Double())
    Notes = Column(String())
    UndistributeStatement = Column(String())
    DistributeTimes = Column(String())
    CeilingNext = Column(Double())
    FloorNext = Column(Double())
    Ceiling = Column(Double())
    Floor = Column(Double())
    MainForm = Column(Integer())
    CashDiviCeiling = Column(Double())
    CashDiviFloor = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())
    DiviEndDate = Column(String())
    DividendImplementDate = Column(String())
    EventProcedure = Column(Integer())
    EventProcedureDesc = Column(String())
    BonusSHRatioAdjusted = Column(Double())
    TranAddRatioAdjusted = Column(Double())
    CashDiviRMBAdjusted = Column(Double())
    DiviObjectNew = Column(Integer())
    BonusShareArrivalDate = Column(String())
    SchemeType = Column(Integer())
    ExDiviRefPrice = Column(Double())
    DiviIntentPublDate = Column(String())
    DividendBaseDate = Column(String())
    ProposalSN = Column(Integer())
    LatestInfoPublDate = Column(String())
    SchemeStatement = Column(String())


class LC_CapitalInvest(Base):
    __tablename__ = 'LC_CapitalInvest'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPunlDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    RaisingMethod = Column(Integer())
    InvestProject = Column(String())
    ProjectStatement = Column(String())
    PlannedSum = Column(Double())
    ActualInvestEndDate = Column(String())
    ActualSum = Column(Double())
    Industry = Column(Integer())
    InvestField = Column(Integer())
    ProceedingStatement = Column(String())
    IfSwitched = Column(Integer())
    ProjectSwitchedTo = Column(String())
    SumSwitched = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())
    InnerCode = Column(Integer())
    PurchaseType = Column(Integer())
    BookValue = Column(Double())
    AppraisalValue = Column(Double())
    PurchasePrice = Column(Double())
    EquityRatio = Column(Double())
    Transferor = Column(String())
    Relationship = Column(Integer())
    InvolvedStock = Column(Integer())
    TransferorNature = Column(Integer())
    TargetName = Column(String())
    TargetNature = Column(Integer())
    InsertTime = Column(String())


class CS_StockCapFlowIndex(Base):
    __tablename__ = 'CS_StockCapFlowIndex'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    TradingDay = Column(String())
    TimeRange = Column(Integer())
    SmallBuyValue = Column(Double())
    SmallSellValue = Column(Double())
    SmallBuyVolume = Column(Double())
    SmallSellVolume = Column(Double())
    SmallBuyNum = Column(Double())
    SmallSellNum = Column(Double())
    SmallNetBuyValue = Column(Double())
    SmallNetBuyVolume = Column(Double())
    SmallBValueRatio = Column(Double())
    SmallSValueRatio = Column(Double())
    SmallBVolumeRatio = Column(Double())
    SmallSVolumeRatio = Column(Double())
    SmallNBValueRatio = Column(Double())
    SmallNBVFloatMVRatio = Column(Double())
    SmallNBVolumeRatio = Column(Double())
    SmallNBVFloatSRatio = Column(Double())
    SmallActBuyValue = Column(Double())
    SmallActSellValue = Column(Double())
    SmallActBuyVolume = Column(Double())
    SmallActSellVolume = Column(Double())
    SmallActBuyNum = Column(Double())
    SmallActSellNum = Column(Double())
    SmallNetActBuyValue = Column(Double())
    SmallNetActBuyVolume = Column(Double())
    SmallABValueRatio = Column(Double())
    SmallASValueRatio = Column(Double())
    SmallABVolumeRatio = Column(Double())
    SmallASVolumeRatio = Column(Double())
    SmallNABValueRatio = Column(Double())
    SmallNABVFloatMVRatio = Column(Double())
    SmallNABVolumeRatio = Column(Double())
    SmallNABVFloatSRatio = Column(Double())
    MediumBuyValue = Column(Double())
    MediumSellValue = Column(Double())
    MediumBuyVolume = Column(Double())
    MediumSellVolume = Column(Double())
    MediumBuyNum = Column(Double())
    MediumSellNum = Column(Double())
    MediumNetBuyValue = Column(Double())
    MediumNetBuyVolume = Column(Double())
    MediumBValueRatio = Column(Double())
    MediumSValueRatio = Column(Double())
    MediumBVolumeRatio = Column(Double())
    MediumSVolumeRatio = Column(Double())
    MediumNBValueRatio = Column(Double())
    MediumNBVFloatMVRatio = Column(Double())
    MediumNBVolumeRatio = Column(Double())
    MediumNBVFloatSRatio = Column(Double())
    MediumActBuyValue = Column(Double())
    MediumActSellValue = Column(Double())
    MediumActBuyVolume = Column(Double())
    MediumActSellVolume = Column(Double())
    MediumActBuyNum = Column(Double())
    MediumActSellNum = Column(Double())
    MediumNetActBuyValue = Column(Double())
    MediumNetActBuyVolume = Column(Double())
    MediumABValueRatio = Column(Double())
    MediumASValueRatio = Column(Double())
    MediumABVolumeRatio = Column(Double())
    MediumASVolumeRatio = Column(Double())
    MediumNABValueRatio = Column(Double())
    MediumNABVFloatMVRatio = Column(Double())
    MediumNABVolumeRatio = Column(Double())
    MediumNABVFloatSRatio = Column(Double())
    LargeBuyValue = Column(Double())
    LargeSellValue = Column(Double())
    LargeBuyVolume = Column(Double())
    LargeSellVolume = Column(Double())
    LargeBuyNum = Column(Double())
    LargeSellNum = Column(Double())
    LargeNetBuyValue = Column(Double())
    LargeNetBuyVolume = Column(Double())
    LargeBValueRatio = Column(Double())
    LargeSValueRatio = Column(Double())
    LargeBVolumeRatio = Column(Double())
    LargeSVolumeRatio = Column(Double())
    LargeNBValueRatio = Column(Double())
    LargeNBVFloatMVRatio = Column(Double())
    LargeNBVolumeRatio = Column(Double())
    LargeNBVFloatSRatio = Column(Double())
    LargeActBuyValue = Column(Double())
    LargeActSellValue = Column(Double())
    LargeActBuyVolume = Column(Double())
    LargeActSellVolume = Column(Double())
    LargeActBuyNum = Column(Double())
    LargeActSellNum = Column(Double())
    LargeNetActBuyValue = Column(Double())
    LargeNetActBuyVolume = Column(Double())
    LargeABValueRatio = Column(Double())
    LargeASValueRatio = Column(Double())
    LargeABVolumeRatio = Column(Double())
    LargeASVolumeRatio = Column(Double())
    LargeNABValueRatio = Column(Double())
    LargeNABVFloatMVRatio = Column(Double())
    LargeNABVolumeRatio = Column(Double())
    LargeNABVFloatSRatio = Column(Double())
    HugeBuyValue = Column(Double())
    HugeSellValue = Column(Double())
    HugeBuyVolume = Column(Double())
    HugeSellVolume = Column(Double())
    HugeBuyNum = Column(Double())
    HugeSellNum = Column(Double())
    HugeNetBuyValue = Column(Double())
    HugeNetBuyVolume = Column(Double())
    HugeBValueRatio = Column(Double())
    HugeSValueRatio = Column(Double())
    HugeBVolumeRatio = Column(Double())
    HugeSVolumeRatio = Column(Double())
    HugeNBValueRatio = Column(Double())
    HugeNBVFloatMVRatio = Column(Double())
    HugeNBVolumeRatio = Column(Double())
    HugeNBVFloatSRatio = Column(Double())
    HugeActBuyValue = Column(Double())
    HugeActSellValue = Column(Double())
    HugeActBuyVolume = Column(Double())
    HugeActSellVolume = Column(Double())
    HugeActBuyNum = Column(Double())
    HugeActSellNum = Column(Double())
    HugeNetActBuyValue = Column(Double())
    HugeNetActBuyVolume = Column(Double())
    HugeABValueRatio = Column(Double())
    HugeASValueRatio = Column(Double())
    HugeABVolumeRatio = Column(Double())
    HugeASVolumeRatio = Column(Double())
    HugeNABValueRatio = Column(Double())
    HugeNABVFloatMVRatio = Column(Double())
    HugeNABVolumeRatio = Column(Double())
    HugeNABVFloatSRatio = Column(Double())
    MainBuyValue = Column(Double())
    MainSellValue = Column(Double())
    MainBuyVolume = Column(Double())
    MainSellVolume = Column(Double())
    MainBuyNum = Column(Double())
    MainSellNum = Column(Double())
    MainNetBuyValue = Column(Double())
    MainNetBuyVolume = Column(Double())
    MainBValueRatio = Column(Double())
    MainSValueRatio = Column(Double())
    MainBVolumeRatio = Column(Double())
    MainSVolumeRatio = Column(Double())
    MainNBValueRatio = Column(Double())
    MainNBVFloatMVRatio = Column(Double())
    MainNBVolumeRatio = Column(Double())
    MainNBVFloatSRatio = Column(Double())
    MainActBuyValue = Column(Double())
    MainActSellValue = Column(Double())
    MainActBuyVolume = Column(Double())
    MainActSellVolume = Column(Double())
    MainActBuyNum = Column(Double())
    MainActSellNum = Column(Double())
    MainNetActBuyValue = Column(Double())
    MainNetActBuyVolume = Column(Double())
    MainABValueRatio = Column(Double())
    MainASValueRatio = Column(Double())
    MainABVolumeRatio = Column(Double())
    MainASVolumeRatio = Column(Double())
    MainNABValueRatio = Column(Double())
    MainNABVFloatMVRatio = Column(Double())
    MainNABVolumeRatio = Column(Double())
    MainNABVFloatSRatio = Column(Double())
    TotalBuyValue = Column(Double())
    TotalSellValue = Column(Double())
    TotalBuyVolume = Column(Double())
    TotalSellVolume = Column(Double())
    TotalBuyNum = Column(Double())
    TotalSellNum = Column(Double())
    TotalNetBuyValue = Column(Double())
    TotalNetBuyVolume = Column(Double())
    TotalBValueRatio = Column(Double())
    TotalSValueRatio = Column(Double())
    TotalBVolumeRatio = Column(Double())
    TotalSVolumeRatio = Column(Double())
    TotalNBValueRatio = Column(Double())
    TotalNBVFloatMVRatio = Column(Double())
    TotalNBVolumeRatio = Column(Double())
    TotalNBVFloatSRatio = Column(Double())
    TotalActBuyValue = Column(Double())
    TotalActSellValue = Column(Double())
    TotalActBuyVolume = Column(Double())
    TotalActSellVolume = Column(Double())
    TotalActBuyNum = Column(Double())
    TotalActSellNum = Column(Double())
    TotalNetActBuyValue = Column(Double())
    TotalNetActBuyVolume = Column(Double())
    TotalABValueRatio = Column(Double())
    TotalASValueRatio = Column(Double())
    TotalABVolumeRatio = Column(Double())
    TotalASVolumeRatio = Column(Double())
    TotalNABValueRatio = Column(Double())
    TotalNABVFloatMVRatio = Column(Double())
    TotalNABVolumeRatio = Column(Double())
    TotalNABVFloatSRatio = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class CS_TurnoverVolTecIndex(Base):
    __tablename__ = 'CS_TurnoverVolTecIndex'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    GilCode = Column(String())
    TradingDay = Column(String())
    IndexCycle = Column(Integer())
    SecuMarket = Column(Integer())
    AMA5 = Column(Double())
    AMA10 = Column(Double())
    AMA20 = Column(Double())
    AMA30 = Column(Double())
    AMA60 = Column(Double())
    AMA120 = Column(Double())
    AMA250 = Column(Double())
    VMA5 = Column(Double())
    VMA10 = Column(Double())
    VMA20 = Column(Double())
    VMA30 = Column(Double())
    VMA60 = Column(Double())
    VMA120 = Column(Double())
    VMA250 = Column(Double())
    VMACD_EMA12 = Column(Double())
    VMACD_EMA26 = Column(Double())
    VMACD_DIFF = Column(Double())
    VMACD_DEA = Column(Double())
    VMACD_MACD = Column(Double())
    VolumeRatio = Column(Double())
    VOSC = Column(Double())
    TAPI_TAPI = Column(Double())
    TAPI_TAPIMA = Column(Double())
    VSTD = Column(Double())
    VROC = Column(Double())
    VR = Column(Double())
    VRSI = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class CS_StockPatterns(Base):
    __tablename__ = 'CS_StockPatterns'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    TradingDay = Column(String())
    GilCode = Column(String())
    SecuMarket = Column(Integer())
    IfHighestHPriceRW = Column(Integer())
    IfHighestHPriceRM = Column(Integer())
    IfHighestHPriceRMThree = Column(Integer())
    IfHighestHPriceRMSix = Column(Integer())
    IfHighestHPriceRY = Column(Integer())
    IfHighestHPriceSL = Column(Integer())
    IfHighestCPriceRW = Column(Integer())
    IfHighestCPriceRM = Column(Integer())
    IfHighestCPriceRMThree = Column(Integer())
    IfHighestCPriceRMSix = Column(Integer())
    IfHighestCPriceRY = Column(Integer())
    IfHighestCPriceSL = Column(Integer())
    IfHighestTVolumeRW = Column(Integer())
    IfHighestTVolumeRM = Column(Integer())
    IfHighestTVRMThree = Column(Integer())
    IfHighestTVolumeRMSix = Column(Integer())
    IfHighestTVolumeRY = Column(Integer())
    IfHighestTVolumeSL = Column(Integer())
    IfHighestTValueRW = Column(Integer())
    IfHighestTValueRM = Column(Integer())
    IfHighestTValueRMThree = Column(Integer())
    IfHighestTValueRMSix = Column(Integer())
    IfHighestTValueRY = Column(Integer())
    IfHighestTValueSL = Column(Integer())
    HighestHPTimesSL = Column(Integer())
    HighestHPTimesRW = Column(Integer())
    HighestHPTimesRM = Column(Integer())
    HighestHPTimesRMThree = Column(Integer())
    HighestHPTimesRMSix = Column(Integer())
    HighestHPTimesRY = Column(Integer())
    IfLowestLPriceRW = Column(Integer())
    IfLowestLPriceRM = Column(Integer())
    IfLowestLPRMThree = Column(Integer())
    IfLowestLPriceRMSix = Column(Integer())
    IfLowestLPriceRY = Column(Integer())
    IfLowestLPriceSL = Column(Integer())
    IfLowestClosePriceRW = Column(Integer())
    IfLowestClosePriceRM = Column(Integer())
    IfLowestCPriceRMThree = Column(Integer())
    IfLowestCPriceRMSix = Column(Integer())
    IfLowestClosePriceRY = Column(Integer())
    IfLowestClosePriceSL = Column(Integer())
    IfLowestTVolumeRW = Column(Integer())
    IfLowestTVolumeRM = Column(Integer())
    IfLowestTVolumeRMThree = Column(Integer())
    IfLowestVolumeRMSix = Column(Integer())
    IfLowestTVolumeRY = Column(Integer())
    IfLowestTVolumeSL = Column(Integer())
    IfLowestTValueRW = Column(Integer())
    IfLowestTValueRM = Column(Integer())
    IfLowestTValueRMThree = Column(Integer())
    IfLowestTValueRMSix = Column(Integer())
    IfLowestTValueRY = Column(Integer())
    IfLowestTValueSL = Column(Integer())
    LowestLowPriceTimesSL = Column(Integer())
    LowestLowPriceTimesRW = Column(Integer())
    LowestLowPriceTimesRM = Column(Integer())
    LowestLPTimesRMThree = Column(Integer())
    LowestLPTimesRMSix = Column(Integer())
    LowestLPTimesRY = Column(Integer())
    RisingUpDays = Column(Integer())
    FallingDownDays = Column(Integer())
    VolumeRisingUpDays = Column(Integer())
    VolumeFallingDownDays = Column(Integer())
    BreakingMAverageFive = Column(Integer())
    BreakingMAverageTen = Column(Integer())
    BreakingMAverageTwenty = Column(Integer())
    BreakingMAverageSixty = Column(Integer())
    RaisingLimitInNDays = Column(String())
    MAverageArrangements = Column(Integer())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class QT_DailyQuote(Base):
    __tablename__ = 'QT_DailyQuote'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    TradingDay = Column(String())
    PrevClosePrice = Column(Double())
    OpenPrice = Column(Double())
    HighPrice = Column(Double())
    LowPrice = Column(Double())
    ClosePrice = Column(Double())
    TurnoverVolume = Column(Double())
    TurnoverValue = Column(Double())
    TurnoverDeals = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())


class QT_StockPerformance(Base):
    __tablename__ = 'QT_StockPerformance'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    TradingDay = Column(String())
    PrevClosePrice = Column(Double())
    OpenPrice = Column(Double())
    HighPrice = Column(Double())
    LowPrice = Column(Double())
    ClosePrice = Column(Double())
    TurnoverVolume = Column(Double())
    TurnoverValue = Column(Double())
    ChangePCT = Column(Double())
    RangePCT = Column(Double())
    TurnoverRate = Column(Double())
    AvgPrice = Column(Double())
    Ifsuspend = Column(Integer())
    TurnoverValueRW = Column(Double())
    TurnoverVolumeRW = Column(Double())
    ChangePCTRW = Column(Double())
    RangePCTRW = Column(Double())
    TurnoverRateRW = Column(Double())
    AvgPriceRW = Column(Double())
    HighPriceRW = Column(Double())
    LowPriceRW = Column(Double())
    HighestClosePriceRW = Column(Double())
    LowestClosePriceRW = Column(Double())
    TurnoverValuePerDayRW = Column(Double())
    TurnoverRatePerDayRW = Column(Double())
    TurnoverValueTW = Column(Double())
    TurnoverVolumeTW = Column(Double())
    ChangePCTTW = Column(Double())
    RangePCTTW = Column(Double())
    TurnoverRateTW = Column(Double())
    AvgPriceTW = Column(Double())
    HighPriceTW = Column(Double())
    LowPriceTW = Column(Double())
    HighestClosePriceTW = Column(Double())
    LowestClosePriceTW = Column(Double())
    TurnoverValuePerDayTW = Column(Double())
    TurnoverRatePerDayTW = Column(Double())
    TurnoverValueRM = Column(Double())
    TurnoverVolumeRM = Column(Double())
    ChangePCTRM = Column(Double())
    RangePCTRM = Column(Double())
    TurnoverRateRM = Column(Double())
    AvgPriceRM = Column(Double())
    HighPriceRM = Column(Double())
    LowPriceRM = Column(Double())
    HighestClosePriceRM = Column(Double())
    LowestClosePriceRM = Column(Double())
    TurnoverValuePerDayRM = Column(Double())
    TurnoverRatePerDayRM = Column(Double())
    TurnoverValueTM = Column(Double())
    TurnoverVolumeTM = Column(Double())
    ChangePCTTM = Column(Double())
    RangePCTTM = Column(Double())
    TurnoverRateTM = Column(Double())
    AvgPriceTM = Column(Double())
    HighPriceTM = Column(Double())
    LowPriceTM = Column(Double())
    HighestClosePriceTM = Column(Double())
    LowestClosePriceTM = Column(Double())
    TurnoverValuePerDayTM = Column(Double())
    TurnoverRatePerDayTM = Column(Double())
    TurnoverValueRMThree = Column(Double())
    TurnoverVolumeRMThree = Column(Double())
    ChangePCTRMThree = Column(Double())
    RangePCTRMThree = Column(Double())
    TurnoverRateRMThree = Column(Double())
    TurnoverValueRMSix = Column(Double())
    TurnoverVolumeRMSix = Column(Double())
    ChangePCTRMSix = Column(Double())
    RangePCTRMSix = Column(Double())
    TurnoverRateRMSix = Column(Double())
    TurnoverValueRY = Column(Double())
    TurnoverVolumeRY = Column(Double())
    ChangePCTRY = Column(Double())
    RangePCTRY = Column(Double())
    TurnoverRateRY = Column(Double())
    AvgPriceRY = Column(Double())
    HighPriceRY = Column(Double())
    LowPriceRY = Column(Double())
    HighestClosePriceRY = Column(Double())
    LowestClosePriceRY = Column(Double())
    TurnoverValuePDayRY = Column(Double())
    TurnoverRatePDayRY = Column(Double())
    TurnoverValueYTD = Column(Double())
    TurnoverVolumeYTD = Column(Double())
    ChangePCTYTD = Column(Double())
    RangePCTYTD = Column(Double())
    TurnoverRateYTD = Column(Double())
    AvgPriceYTD = Column(Double())
    HighPriceYTD = Column(Double())
    LowPriceYTD = Column(Double())
    HighestClosePriceYTD = Column(Double())
    LowestClosePriceYTD = Column(Double())
    TurnoverValuePerDayYTD = Column(Double())
    TurnoverRatePerDayYTD = Column(Double())
    HighAdjustedPrice = Column(Double())
    HighAdjustedPriceDate = Column(String())
    LowAdjustedPrice = Column(Double())
    LowAdjustedPriceDate = Column(String())
    BetaLargeCapIndex = Column(Double())
    BetaCompositeIndex = Column(Double())
    BetaSYWGIndustryIndex = Column(Double())
    BetaMidCapIndex = Column(Double())
    BetaWeekly = Column(Double())
    AdjustBetaWeekly = Column(Double())
    AlphaLargeCapIndex = Column(Double())
    AlphaCompositeIndex = Column(Double())
    AlphaSYWGIndustryIndex = Column(Double())
    AlphMidCapIndex = Column(Double())
    YearVolatilityByDay = Column(Double())
    YearVolatilityByWeek = Column(Double())
    YearSharpeRatio = Column(Double())
    MarketIndexRORArithAvg = Column(Double())
    MarketIndexRORGeomMean = Column(Double())
    TotalMV = Column(Double())
    NegotiableMV = Column(Double())
    UpdateTime = Column(String())
    InsertTime = Column(String())
    JSID = Column(Integer())
    TurnoverRateFreeFloat = Column(Double())
    TurnoverRateFFTRW = Column(Double())
    TurnoverRatePDFFTRW = Column(Double())
    TurnoverRateFFTTW = Column(Double())
    TurnoverRatePDFFTTW = Column(Double())
    TurnoverRateFFTRM = Column(Double())
    TurnoverRatePDFFTRM = Column(Double())
    TurnoverRateFFTTM = Column(Double())
    TurnoverRatePDFFTTM = Column(Double())
    TurnoverRateFFTRMThree = Column(Double())
    TurnoverRateFFTRMSix = Column(Double())
    TurnoverRateFFTRY = Column(Double())
    TurnoverRatePDFFTRY = Column(Double())
    TurnoverRateFFTYTD = Column(Double())
    TurnoverRatePDFFTYTD = Column(Double())


class LC_SuspendResumption(Base):
    __tablename__ = 'LC_SuspendResumption'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(Integer())
    SuspendDate = Column(String())
    SuspendTime = Column(String())
    SuspendReason = Column(String())
    SuspendStatement = Column(Integer())
    SuspendTerm = Column(String())
    ResumptionDate = Column(String())
    ResumptionTime = Column(String())
    ResumptionStatement = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    InsertTime = Column(String())
    SuspendType = Column(Integer())


class LC_BalanceSheetAll(Base):
    __tablename__ = 'LC_BalanceSheetAll'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    BulletinType = Column(Integer())
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    IfAdjusted = Column(Integer())
    IfMerged = Column(Integer())
    AccountingStandards = Column(Integer())
    EnterpriseType = Column(Integer())
    CashEquivalents = Column(Double())
    ClientDeposit = Column(Double())
    TradingAssets = Column(Double())
    BillReceivable = Column(Double())
    DividendReceivable = Column(Double())
    InterestReceivable = Column(Double())
    AccountReceivable = Column(Double())
    OtherReceivable = Column(Double())
    AdvancePayment = Column(Double())
    Inventories = Column(Double())
    BearerBiologicalAssets = Column(Double())
    DeferredExpense = Column(Double())
    NonCurrentAssetIn1Year = Column(Double())
    OtherCurrentAssets = Column(Double())
    CAExceptionalItems = Column(Double())
    CAAdjustmentItems = Column(Double())
    TotalCurrentAssets = Column(Double())
    HoldForSaleAssets = Column(Double())
    HoldToMaturityInvestments = Column(Double())
    InvestmentProperty = Column(Double())
    LongtermEquityInvest = Column(Double())
    LongtermReceivableAccount = Column(Double())
    FixedAssets = Column(Double())
    ConstructionMaterials = Column(Double())
    ConstruInProcess = Column(Double())
    FixedAssetsLiquidation = Column(Double())
    BiologicalAssets = Column(Double())
    OilGasAssets = Column(Double())
    IntangibleAssets = Column(Double())
    SeatCosts = Column(Double())
    DevelopmentExpenditure = Column(Double())
    GoodWill = Column(Double())
    LongDeferredExpense = Column(Double())
    DeferredTaxAssets = Column(Double())
    OtherNonCurrentAssets = Column(Double())
    NCAExceptionalItems = Column(Double())
    NCAAdjustmentItems = Column(Double())
    TotalNonCurrentAssets = Column(Double())
    LoanAndAccountReceivables = Column(Double())
    SettlementProvi = Column(Double())
    ClientProvi = Column(Double())
    DepositInInterbank = Column(Double())
    RMetal = Column(Double())
    LendCapital = Column(Double())
    DerivativeAssets = Column(Double())
    BoughtSellbackAssets = Column(Double())
    LoanAndAdvance = Column(Double())
    InsuranceReceivables = Column(Double())
    ReceivableSubrogationFee = Column(Double())
    ReinsuranceReceivables = Column(Double())
    ReceivableUnearnedR = Column(Double())
    ReceivableClaimsR = Column(Double())
    ReceivableLifeR = Column(Double())
    ReceivableLTHealthR = Column(Double())
    InsurerImpawnLoan = Column(Double())
    FixedDeposit = Column(Double())
    RefundableDeposit = Column(Double())
    RefundableCapitalDeposit = Column(Double())
    IndependenceAccountAssets = Column(Double())
    OtherAssets = Column(Double())
    AExceptionalItems = Column(Double())
    AAdjustmentItems = Column(Double())
    TotalAssets = Column(Double())
    ShortTermLoan = Column(Double())
    ImpawnedLoan = Column(Double())
    TradingLiability = Column(Double())
    NotesPayable = Column(Double())
    AccountsPayable = Column(Double())
    STBondsPayable = Column(Double())
    AdvanceReceipts = Column(Double())
    SalariesPayable = Column(Double())
    DividendPayable = Column(Double())
    TaxsPayable = Column(Double())
    InterestPayable = Column(Double())
    OtherPayable = Column(Double())
    AccruedExpense = Column(Double())
    DeferredProceeds = Column(Double())
    NonCurrentLiabilityIn1Year = Column(Double())
    OtherCurrentLiability = Column(Double())
    CLExceptionalItems = Column(Double())
    CLAdjustmentItems = Column(Double())
    TotalCurrentLiability = Column(Double())
    LongtermLoan = Column(Double())
    BondsPayable = Column(Double())
    LongtermAccountPayable = Column(Double())
    SpecificAccountPayable = Column(Double())
    EstimateLiability = Column(Double())
    DeferredTaxLiability = Column(Double())
    OtherNonCurrentLiability = Column(Double())
    NCLExceptionalItems = Column(Double())
    NCLAdjustmentItems = Column(Double())
    TotalNonCurrentLiability = Column(Double())
    BorrowingFromCentralBank = Column(Double())
    DepositOfInterbank = Column(Double())
    BorrowingCapital = Column(Double())
    DerivativeLiability = Column(Double())
    SoldBuybackSecuProceeds = Column(Double())
    Deposit = Column(Double())
    ProxySecuProceeds = Column(Double())
    SubIssueSecuProceeds = Column(Double())
    DepositsReceived = Column(Double())
    AdvanceInsurance = Column(Double())
    CommissionPayable = Column(Double())
    ReinsurancePayables = Column(Double())
    CompensationPayable = Column(Double())
    PolicyDividendPayable = Column(Double())
    InsurerDepositInvestment = Column(Double())
    UnearnedPremiumReserve = Column(Double())
    OutstandingClaimReserve = Column(Double())
    LifeInsuranceReserve = Column(Double())
    LTHealthInsuranceLR = Column(Double())
    IndependenceLiability = Column(Double())
    OtherLiability = Column(Double())
    LExceptionalItems = Column(Double())
    LAdjustmentItems = Column(Double())
    TotalLiability = Column(Double())
    PaidInCapital = Column(Double())
    CapitalReserveFund = Column(Double())
    SurplusReserveFund = Column(Double())
    RetainedProfit = Column(Double())
    TreasuryStock = Column(Double())
    OrdinaryRiskReserveFund = Column(Double())
    ForeignCurrencyReportConvDiff = Column(Double())
    UncertainedInvestmentLoss = Column(Double())
    OtherReserves = Column(Double())
    SpecificReserves = Column(Double())
    SEExceptionalItems = Column(Double())
    SEAdjustmentItems = Column(Double())
    SEWithoutMI = Column(Double())
    MinorityInterests = Column(Double())
    OtherItemsEffectingSE = Column(Double())
    TotalShareholderEquity = Column(Double())
    LEExceptionalItems = Column(Double())
    LEAdjustmentItems = Column(Double())
    TotalLiabilityAndEquity = Column(Double())
    SpecialFieldRemark = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    IfComplete = Column(Integer())
    LPreferStock = Column(Double())
    LPerpetualDebt = Column(Double())
    OtherEquityinstruments = Column(Double())
    EPreferStock = Column(Double())
    EPerpetualDebt = Column(Double())
    OtherCompositeIncome = Column(Double())
    HoldAndFSAssets = Column(Double())
    HoldAndFSLi = Column(Double())
    LongSalariesPay = Column(Double())
    LongDeferIncome = Column(Double())
    BillAccReceivable = Column(Double())
    ContractualAssets = Column(Double())
    DebtInvestment = Column(Double())
    OthDebtInvestment = Column(Double())
    OthEquityInstrument = Column(Double())
    OthNonCurFinAssets = Column(Double())
    NotAccountsPayable = Column(Double())
    ContractLiability = Column(Double())
    TradeRiskRSRVFd = Column(Double())
    OtherReceivableED = Column(Double())
    OtherPayableED = Column(Double())
    ReceivablesFin = Column(Double())
    Financing = Column(Double())
    FinLeaseReceivable = Column(Double())
    ResReiReceContracts = Column(Double())
    UsufructAssets = Column(Double())
    AbsInterDeposits = Column(Double())
    InsContractReserve = Column(Double())
    LeaseLiabilities = Column(Double())
    FinLeasesPayable = Column(Double())
    TotalFixedAsset = Column(Double())
    TConstruInProcess = Column(Double())
    DepositInAssociate = Column(Double())
    DebtAssets = Column(Double())
    DebitofAssociate = Column(Double())
    InfoSourceCode = Column(Integer())
    InsertTime = Column(String())
    Cash = Column(Double())
    DepositInCentralBank = Column(Double())
    AmongTradingAssets = Column(Double())
    AmongFinAetAtFValTPL = Column(Double())
    Receivables = Column(Double())
    CashDepositReceive = Column(Double())
    PledgDepositReceive = Column(Double())
    SettlementReceive = Column(Double())
    RiskOfLossReceive = Column(Double())
    FeeCommissionReceive = Column(Double())
    AmongDebtInvestment = Column(Double())
    AmongFinAetAtAmorCost = Column(Double())
    AmongOthDebtInvest = Column(Double())
    AmongFinAetAtFValTOCI = Column(Double())
    AmongOthEquInstrument = Column(Double())
    AmongEquInsAtFValTOCI = Column(Double())
    FutureMemberInvestment = Column(Double())
    FinancialInvestment = Column(Double())
    ShortTermBondPay = Column(Double())
    AmongTradingLiability = Column(Double())
    AmongFinLiaAtFValTPL = Column(Double())
    Payables = Column(Double())
    CashDepositPay = Column(Double())
    PledgDepositPay = Column(Double())
    FutureProtectFundPay = Column(Double())
    GuarantCompensateRSRV = Column(Double())
    GuaranteeReserve = Column(Double())
    FutureRiskReserve = Column(Double())
    LTInsContractReserve = Column(Double())
    LTAccountPayableTotal = Column(Double())
    AgencyBusAssets = Column(Double())
    FinAssetsAtFValTOCI = Column(Double())
    SubLoan = Column(Double())
    PubWBiologicalAssets = Column(Double())
    AgencyBusLiability = Column(Double())
    SECParentCompanyOwners = Column(Double())
    TSEExceptionalItems = Column(Double())


class LC_IncomeStatementAll(Base):
    __tablename__ = 'LC_IncomeStatementAll'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    BulletinType = Column(Integer())
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    IfAdjusted = Column(Integer())
    IfMerged = Column(Integer())
    AccountingStandards = Column(Integer())
    EnterpriseType = Column(Integer())
    TotalOperatingRevenue = Column(Double())
    OperatingRevenue = Column(Double())
    NetInterestIncome = Column(Double())
    InterestIncome = Column(Double())
    InterestExpense = Column(Double())
    NetCommissionIncome = Column(Double())
    CommissionIncome = Column(Double())
    CommissionExpense = Column(Double())
    NetProxySecuIncome = Column(Double())
    NetSubIssueSecuIncome = Column(Double())
    NetTrustIncome = Column(Double())
    PremiumsEarned = Column(Double())
    PremiumsIncome = Column(Double())
    ReinsuranceIncome = Column(Double())
    Reinsurance = Column(Double())
    UnearnedPremiumReserve = Column(Double())
    OtherOperatingRevenue = Column(Double())
    SpecialItemsOR = Column(Double())
    AdjustmentItemsOR = Column(Double())
    TotalOperatingCost = Column(Double())
    OperatingPayout = Column(Double())
    RefundedPremiums = Column(Double())
    CompensationExpense = Column(Double())
    AmortizationExpense = Column(Double())
    PremiumReserve = Column(Double())
    AmortizationPremiumReserve = Column(Double())
    PolicyDividendPayout = Column(Double())
    ReinsuranceCost = Column(Double())
    OperatingAndAdminExpense = Column(Double())
    AmortizationReinsuranceCost = Column(Double())
    InsuranceCommissionExpense = Column(Double())
    OtherOperatingCost = Column(Double())
    OperatingCost = Column(Double())
    OperatingTaxSurcharges = Column(Double())
    OperatingExpense = Column(Double())
    AdministrationExpense = Column(Double())
    FinancialExpense = Column(Double())
    AssetImpairmentLoss = Column(Double())
    SpecialItemsTOC = Column(Double())
    AdjustmentItemsTOC = Column(Double())
    OtherNetRevenue = Column(Double())
    FairValueChangeIncome = Column(Double())
    InvestIncome = Column(Double())
    InvestIncomeAssociates = Column(Double())
    ExchangeIncome = Column(Double())
    OtherItemsEffectingOP = Column(Double())
    AdjustedItemsEffectingOP = Column(Double())
    OperatingProfit = Column(Double())
    NonoperatingIncome = Column(Double())
    NonoperatingExpense = Column(Double())
    NonCurrentAssetssDealLoss = Column(Double())
    OtherItemsEffectingTP = Column(Double())
    AdjustedItemsEffectingTP = Column(Double())
    TotalProfit = Column(Double())
    IncomeTaxCost = Column(Double())
    UncertainedInvestmentLosses = Column(Double())
    OtherItemsEffectingNP = Column(Double())
    AdjustedItemsEffectingNP = Column(Double())
    NetProfit = Column(Double())
    NPParentCompanyOwners = Column(Double())
    MinorityProfit = Column(Double())
    OtherItemsEffectingNPP = Column(Double())
    AdjustedItemsEffectingNPP = Column(Double())
    OtherCompositeIncome = Column(Double())
    AdjustedItemsEffectingCI = Column(Double())
    TotalCompositeIncome = Column(Double())
    CIParentCompanyOwners = Column(Double())
    CIMinorityOwners = Column(Double())
    AdjustedItemsEffectingPCI = Column(Double())
    BasicEPS = Column(Double())
    DilutedEPS = Column(Double())
    SpecialFieldRemark = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    IfComplete = Column(Integer())
    OCIParentCompanyOwners = Column(Double())
    OCINotInIncomeStatement = Column(Double())
    OCIReMearsure = Column(Double())
    OCIEquityNotInIS = Column(Double())
    OCIInIncomeStatement = Column(Double())
    OCIEquityInIS = Column(Double())
    OCIFairValue = Column(Double())
    OCIToMaturityFA = Column(Double())
    OCICFLoss = Column(Double())
    OCIForeignCurrencyFSA = Column(Double())
    OCIOthers = Column(Double())
    OCIMinorityOwners = Column(Double())
    OtherRevenue = Column(Double())
    AssetDealIncome = Column(Double())
    OperSustCateg = Column(Double())
    OperSustNetP = Column(Double())
    DisconOperNetP = Column(Double())
    OwnershipCateg = Column(Double())
    PreInsurRSRV = Column(Double())
    NetClaimIncurred = Column(Double())
    NetPremiumReserve = Column(Double())
    AmortisedcostIncome = Column(Double())
    InfoSourceCode = Column(Integer())
    InsertTime = Column(String())
    SalesRevenue = Column(Double())
    OtherOperatingIncome = Column(Double())
    GuaranteeIncome = Column(Double())
    BrokerageIncome = Column(Double())
    InvestBankIncome = Column(Double())
    AssetManageIncome = Column(Double())
    FundManageIncome = Column(Double())
    InvestConsultIncome = Column(Double())
    RiskManageIncome = Column(Double())
    InvestManageIncome = Column(Double())
    OtherAgencyIncome = Column(Double())
    BrokerageExpense = Column(Double())
    InvestBankExpense = Column(Double())
    AssetManageExpense = Column(Double())
    FundManageExpense = Column(Double())
    InvestConsultExpense = Column(Double())
    RiskManageExpense = Column(Double())
    InvestManageExpense = Column(Double())
    OtherAgencyExpense = Column(Double())
    NetFundMgtIncome = Column(Double())
    ExtractFutureRisk = Column(Double())
    WithdrawGuaranteeReser = Column(Double())
    GuarantCompRSRV = Column(Double())
    SalesCost = Column(Double())
    OtherOperationalCost = Column(Double())
    TotalAdminExpense = Column(Double())
    ExplorationCost = Column(Double())
    CreditImpairmentP = Column(Double())
    AssetImpairmentLossP = Column(Double())
    NPCParentCompanyOwners = Column(Double())
    NPOtherEqinstruments = Column(Double())
    OtherItemsEffectingCI = Column(Double())
    CICParentCompanyOwners = Column(Double())
    CIOtherEqinstruments = Column(Double())
    OthDebtInvesChange = Column(Double())
    InterestIncomeFin = Column(Double())
    CreditImpairmentL = Column(Double())
    NetOpenHedgeIncome = Column(Double())
    OthEquFVChange = Column(Double())
    FinAssetROtherCI = Column(Double())
    OtherDebtInvestCIP = Column(Double())
    RAndD = Column(Double())
    InterestFinExp = Column(Double())
    CorporateCRChange = Column(Double())


class LC_CashFlowStatementAll(Base):
    __tablename__ = 'LC_CashFlowStatementAll'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    BulletinType = Column(Integer())
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    IfAdjusted = Column(Integer())
    IfMerged = Column(Integer())
    AccountingStandards = Column(Integer())
    EnterpriseType = Column(Integer())
    GoodsSaleServiceRenderCash = Column(Double())
    TaxLevyRefund = Column(Double())
    NetDepositIncrease = Column(Double())
    NetBorrowingFromCentralBank = Column(Double())
    NetBorrowingFromFinanceCo = Column(Double())
    DrawBackLoansCanceled = Column(Double())
    InterestAndCommissionCashIn = Column(Double())
    NetDealTradingAssets = Column(Double())
    NetBuyBack = Column(Double())
    NetOriginalInsuranceCash = Column(Double())
    NetReinsuranceCash = Column(Double())
    NetInsurerDepositInvestment = Column(Double())
    OtherCashInRelatedOperate = Column(Double())
    SpecialItemsOCIF = Column(Double())
    AdjustmentItemsOCIF = Column(Double())
    SubtotalOperateCashInflow = Column(Double())
    GoodsServicesCashPaid = Column(Double())
    StaffBehalfPaid = Column(Double())
    AllTaxesPaid = Column(Double())
    NetLoanAndAdvanceIncrease = Column(Double())
    NetDepositInCBAndIB = Column(Double())
    NetLendCapital = Column(Double())
    CommissionCashPaid = Column(Double())
    OriginalCompensationPaid = Column(Double())
    NetCashForReinsurance = Column(Double())
    PolicyDividendCashPaid = Column(Double())
    OtherOperateCashPaid = Column(Double())
    SpecialItemsOCOF = Column(Double())
    AdjustmentItemsOCOF = Column(Double())
    SubtotalOperateCashOutflow = Column(Double())
    AdjustmentItemsNOCF = Column(Double())
    NetOperateCashFlow = Column(Double())
    InvestWithdrawalCash = Column(Double())
    Investproceeds = Column(Double())
    FixIntanOtherAssetDispoCash = Column(Double())
    NetCashDealSubCompany = Column(Double())
    OtherCashFromInvestAct = Column(Double())
    SpecialItemsICIF = Column(Double())
    AdjustmentItemsICIF = Column(Double())
    SubtotalInvestCashInflow = Column(Double())
    FixIntanOtherAssetAcquiCash = Column(Double())
    InvestCashPaid = Column(Double())
    NetCashFromSubCompany = Column(Double())
    ImpawnedLoanNetIncrease = Column(Double())
    OtherCashToInvestAct = Column(Double())
    SpecialItemsICOF = Column(Double())
    AdjustmentItemsICOF = Column(Double())
    SubtotalInvestCashOutflow = Column(Double())
    AdjustmentItemsNICF = Column(Double())
    NetInvestCashFlow = Column(Double())
    CashFromInvest = Column(Double())
    CashFromMinoSInvestSub = Column(Double())
    CashFromBondsIssue = Column(Double())
    CashFromBorrowing = Column(Double())
    OtherFinanceActCash = Column(Double())
    SpecialItemsFCIF = Column(Double())
    AdjustmentItemsFCIF = Column(Double())
    SubtotalFinanceCashInflow = Column(Double())
    BorrowingRepayment = Column(Double())
    DividendInterestPayment = Column(Double())
    ProceedsFromSubToMinoS = Column(Double())
    OtherFinanceActPayment = Column(Double())
    SpecialItemsFCOF = Column(Double())
    AdjustmentItemsFCOF = Column(Double())
    SubtotalFinanceCashOutflow = Column(Double())
    AdjustmentItemsNFCF = Column(Double())
    NetFinanceCashFlow = Column(Double())
    ExchanRateChangeEffect = Column(Double())
    OtherItemsEffectingCE = Column(Double())
    AdjustmentItemsCE = Column(Double())
    CashEquivalentIncrease = Column(Double())
    BeginPeriodCash = Column(Double())
    OtherItemsEffectingCEI = Column(Double())
    AdjustmentItemsCEI = Column(Double())
    EndPeriodCashEquivalent = Column(Double())
    NetProfit = Column(Double())
    MinorityProfit = Column(Double())
    AssetsDepreciationReserves = Column(Double())
    FixedAssetDepreciation = Column(Double())
    IntangibleAssetAmortization = Column(Double())
    DeferredExpenseAmort = Column(Double())
    DeferredExpenseDecreased = Column(Double())
    AccruedExpenseAdded = Column(Double())
    FixIntanOtherAssetDispoLoss = Column(Double())
    FixedAssetScrapLoss = Column(Double())
    LossFromFairValueChanges = Column(Double())
    FinancialExpense = Column(Double())
    InvestLoss = Column(Double())
    DeferedTaxAssetDecrease = Column(Double())
    DeferedTaxLiabilityIncrease = Column(Double())
    InventoryDecrease = Column(Double())
    OperateReceivableDecrease = Column(Double())
    OperatePayableIncrease = Column(Double())
    Others = Column(Double())
    SpecialItemsNOCF1 = Column(Double())
    AdjustmentItemsNOCF1 = Column(Double())
    NetOperateCashFlowNotes = Column(Double())
    ContrastAdjutmentNOCF = Column(Double())
    DebtToCaptical = Column(Double())
    CBsExpiringWithin1Y = Column(Double())
    FixedAssetsFinanceLeases = Column(Double())
    CashAtEndOfYear = Column(Double())
    CashAtBeginningOfYear = Column(Double())
    CashEquivalentsAtEndOfYear = Column(Double())
    CashEquivalentsAtBeginning = Column(Double())
    SpecialItemsC = Column(Double())
    AdjustmentItemsC = Column(Double())
    NetIncrInCashAndEquivalents = Column(Double())
    ContrastAdjutmentNC = Column(Double())
    SpecialFieldRemark = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    IfComplete = Column(Integer())
    NetIncBorFunds = Column(Double())
    NetCashRecInVTS = Column(Double())
    NetCashRecAgeUTS = Column(Double())
    NetIncFinAssTraPurp = Column(Double())
    NetIncCapResBusOper = Column(Double())
    NetIncCapResBusInv = Column(Double())
    CashRecIssOthEquIns = Column(Double())
    NetBuyBackFin = Column(Double())
    InterestExpense = Column(Double())
    IncResFunding = Column(Double())
    IncSpeReserves = Column(Double())
    CreditImpairmentL = Column(Double())
    DefProceedsAmo = Column(Double())
    IncEstLiability = Column(Double())
    NetDecFinancialAsset = Column(Double())
    NetCashPaidInVTS = Column(Double())
    UsufructAssetsDA = Column(Double())
    InfoSourceCode = Column(Integer())
    InsertTime = Column(String())
    NetDecLoanAndAdvance = Column(Double())
    NetDecreaseInCBAndIB = Column(Double())
    NetDecFundLending = Column(Double())
    NetDecCapResBusOper = Column(Double())
    NetDecFinAssTraPurp = Column(Double())
    NetIncFinLiaTraPurp = Column(Double())
    BFLAFValOnPLChange = Column(Double())
    NetDecBorrowFromCB = Column(Double())
    NetDecBorFromFinanceCo = Column(Double())
    NetDecInsurDPSTInvest = Column(Double())
    NetDecBorrowingCapital = Column(Double())
    NetDecOfBuyBack = Column(Double())
    NetCashPayAgeUTS = Column(Double())
    NetDecDealTradeAssets = Column(Double())
    NetDecFinLiaTraPurp = Column(Double())
    OpeAndAdmExpForCash = Column(Double())
    NetIncFinancialAsset = Column(Double())
    NetDecBuyBackFin = Column(Double())
    NPParentCompanyOwners = Column(Double())
    ProductBioAssetsDep = Column(Double())
    InterestIncome = Column(Double())
    LeaseLiaIntExp = Column(Double())
    BondIssueExpense = Column(Double())
    ExchangeLoss = Column(Double())
    DeferredTaxCredit = Column(Double())
    SharePayment = Column(Double())
    DecreaseTradeAssets = Column(Double())
    DecAvailableSaleAssets = Column(Double())
    DecreaseLoan = Column(Double())
    InvestPropertyDA = Column(Double())


class LC_IntAssetsDetail(Base):
    __tablename__ = 'LC_IntAssetsDetail'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSourceCode = Column(Integer())
    EndDate = Column(String())
    IfMerged = Column(Integer())
    IfAdjusted = Column(Integer())
    ExpensedRDInput = Column(Double())
    CapitalizedRDInput = Column(Double())
    TotalRDInput = Column(Double())
    RDInputRatio = Column(Double())
    CapitalizedRDInputR = Column(Double())
    RDStaffNum = Column(Double())
    RDStaffNumRatio = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    CoreTechnicalStaffNum = Column(Double())
    CoreTechnicalStaffR = Column(Double())
    CoreTechnologyOutput = Column(Double())
    CoreTechnologyOutputR = Column(Double())


class LC_MainOperIncome(Base):
    __tablename__ = 'LC_MainOperIncome'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    DateType = Column(Integer())
    InfoSource = Column(String())
    IfMerged = Column(Integer())
    IfAdjusted = Column(Integer())
    Classification = Column(Integer())
    SN = Column(Integer())
    Project = Column(String())
    Industry = Column(Integer())
    RegionAndBusiness = Column(Integer())
    MainOperIncome = Column(Double())
    MainOperCost = Column(Double())
    MainOperProfit = Column(Double())
    MainOperIncomeFormerYear = Column(Double())
    MainOperCostFormerYear = Column(Double())
    MainOperProfitFormerYear = Column(Double())
    MainIncomeGrowRateYOY = Column(Double())
    MainICostGrowRateYOY = Column(Double())
    MainProfitGrowRateYOY = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())
    GrossProfit = Column(Double())
    GrossProfitYOY = Column(Double())
    InsertTime = Column(String())
    InfoPublDate = Column(String())
    InfoSourceCode = Column(Integer())
    CurrencyUnit = Column(Integer())
    Level = Column(Integer())
    ParentName = Column(String())
    GrossProfitFormerYear = Column(Double())
    GrossProfitIncrease = Column(Double())


class LC_OperatingStatus(Base):
    __tablename__ = 'LC_OperatingStatus'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    InfoSource = Column(String())
    OperatingStatement = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    InfoPublDate = Column(String())


class LC_AuditOpinion(Base):
    __tablename__ = 'LC_AuditOpinion'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    InfoSource = Column(String())
    AccountingFirms = Column(String())
    InstiBelongedCode = Column(Integer())
    CPA = Column(String())
    OpinionType = Column(Integer())
    OpinionFullText = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    InfoPublDate = Column(String())
    AuditReportsType = Column(Integer())
    InsertTime = Column(String())


class LC_Staff(Base):
    __tablename__ = 'LC_Staff'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EndDate = Column(String())
    InfoSource = Column(String())
    MergeMark = Column(String())
    ClassfiedMethod = Column(Integer())
    TypeName = Column(String())
    YoungestAge = Column(Integer())
    OldestAge = Column(Integer())
    EmployeeSum = Column(Integer())
    RatioInSum = Column(Double())
    Statement = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    TypeCode = Column(Integer())
    InfoPublDate = Column(String())


class LC_RewardStat(Base):
    __tablename__ = 'LC_RewardStat'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    EndDate = Column(String())
    TotalYearPay = Column(Double())
    NumPayManagers = Column(Integer())
    High3Directors = Column(Double())
    High3Managers = Column(Double())
    TotalIndeSupeYearPay = Column(Double())
    Statement = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    TotalIndeSubsidy = Column(Double())


class LC_Warrant(Base):
    __tablename__ = 'LC_Warrant'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    AnnouncementType = Column(Integer())
    DisclosureMethod = Column(Integer())
    EventContent = Column(String())
    ActionDesc = Column(String())
    NewestAdvance = Column(String())
    EventSubject = Column(Integer())
    EventProcedure = Column(Integer())
    ActionWays = Column(Integer())
    CurrencyUnit = Column(Integer())
    SubjectName = Column(String())
    SubjectCode = Column(Integer())
    SubjectAssociation = Column(Integer())
    ObjectName = Column(String())
    ObjectCode = Column(Integer())
    ObjectAssociation = Column(Integer())
    AgreementDate = Column(String())
    IfEnded = Column(Integer())
    Note = Column(String())
    GuaranteeReason = Column(Integer())
    FirstGuaranteeSum = Column(Double())
    LatestGuaranteeSum = Column(Double())
    GuarantorCompany = Column(String())
    GuarantorAssociation = Column(Integer())
    GuaranteeAsset = Column(String())
    SecuredParty = Column(String())
    SecuredPartyAssociation = Column(Integer())
    CounterGuarantor = Column(String())
    CGuarantorAssociation = Column(Integer())
    CGuaranteeAsset = Column(String())
    LendBank = Column(String())
    LendTerm = Column(Double())
    RenewalTerm = Column(Double())
    LendBeginDate = Column(String())
    LendEndDate = Column(String())
    GuaranteeTerm = Column(Double())
    RenewalGuaranteeTerm = Column(Double())
    GuaranteeBeginDate = Column(String())
    GuaranteeEndDate = Column(String())
    DischargeGuaranteeDate = Column(String())
    DischargeGuaranteeWays = Column(Integer())
    IfIllegality = Column(Integer())
    IfOverdue = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    EventCode = Column(String())


class LC_Credit(Base):
    __tablename__ = 'LC_Credit'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    AnnouncementType = Column(Integer())
    DisclosureMethod = Column(Integer())
    EventContent = Column(String())
    ActionDesc = Column(String())
    NewestAdvance = Column(String())
    EventSubject = Column(Integer())
    EventProcedure = Column(Integer())
    ActionWays = Column(Integer())
    CurrencyUnit = Column(Integer())
    SubjectName = Column(String())
    SubjectCode = Column(Integer())
    SubjectAssociation = Column(Integer())
    ObjectName = Column(String())
    ObjectCode = Column(Integer())
    ObjectAssociation = Column(Integer())
    AgreementDate = Column(String())
    IfEnded = Column(Integer())
    Note = Column(String())
    LoanCondition = Column(Integer())
    Borrower = Column(String())
    BorrowerAssociation = Column(Integer())
    MortgageAsset = Column(String())
    Lender = Column(String())
    LenderAssociation = Column(Integer())
    Guarantor = Column(String())
    GuarantorAssociation = Column(Integer())
    GuarantorMortgageAsset = Column(String())
    FirstLoanSum = Column(Double())
    LatestLoanSum = Column(Double())
    LatestRepaymentSum = Column(Double())
    AccumulatedRepaymentSum = Column(Double())
    YearRateStat = Column(String())
    YearRate = Column(Double())
    LoanTerm = Column(Double())
    RenewalTerm = Column(Double())
    LoanBeginDate = Column(String())
    LoanEndDate = Column(String())
    LoanGuaranteeTerm = Column(Double())
    LoanRenewalGuaranteeTerm = Column(Double())
    LoanGuaranteeBeginDate = Column(String())
    LoanGuaranteeEndDate = Column(String())
    LatestRepaymentDate = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())


class LC_SuitArbitration(Base):
    __tablename__ = 'LC_SuitArbitration'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    AnnouncementType = Column(Integer())
    DisclosureMethod = Column(Integer())
    EventContent = Column(String())
    ActionDesc = Column(String())
    NewestAdvance = Column(String())
    EventSubject = Column(Integer())
    EventProcedure = Column(Integer())
    ActionWays = Column(Integer())
    CurrencyUnit = Column(Integer())
    SubjectName = Column(String())
    SubjectCode = Column(Integer())
    SubjectAssociation = Column(Integer())
    ObjectName = Column(String())
    ObjectCode = Column(Integer())
    ObjectAssociation = Column(Integer())
    AgreementDate = Column(String())
    IfEnded = Column(Integer())
    Note = Column(String())
    FirstSuitSum = Column(Double())
    LatestSuitSum = Column(Double())
    Plaintiff = Column(String())
    PlaintiffAssociation = Column(Integer())
    Defendant = Column(String())
    DefendantAssociation = Column(Integer())
    JSRParty = Column(String())
    JSRPartyAssociation = Column(Integer())
    OtherParty = Column(String())
    OtherPartyAssociation = Column(Integer())
    SubjectMatterStat = Column(String())
    SubjectMatter = Column(Integer())
    EventSubjectRole = Column(Integer())
    InquisitionInstitute = Column(String())
    CaseStatus = Column(Integer())
    FirstInstanceStatus = Column(Integer())
    SecondInstanceStatus = Column(Integer())
    SPPStatus = Column(Integer())
    PropertyEnforcement = Column(Integer())
    PropertyEnforced = Column(String())
    PropertyBelonged = Column(Integer())
    AdjudgementStatus = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())


class LC_EntrustInv(Base):
    __tablename__ = 'LC_EntrustInv'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    AnnouncementType = Column(Integer())
    DisclosureMethod = Column(Integer())
    EventContent = Column(String())
    ActionDesc = Column(String())
    NewestAdvance = Column(String())
    EventSubject = Column(Integer())
    EventProcedure = Column(Integer())
    ActionWays = Column(Integer())
    CurrencyUnit = Column(Integer())
    SubjectName = Column(String())
    SubjectCode = Column(Integer())
    SubjectAssociation = Column(Integer())
    ObjectName = Column(String())
    ObjectCode = Column(Integer())
    ObjectAssociation = Column(Integer())
    AgreementDate = Column(String())
    IfEnded = Column(Integer())
    Note = Column(String())
    EntrustFinanceSum = Column(Double())
    EntrustFinanceTerm = Column(Double())
    EntrustFinanceBeginDate = Column(String())
    EntrustFinanceEndDate = Column(String())
    PromisedIncome = Column(String())
    ActualIncome = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())


class LC_Regroup(Base):
    __tablename__ = 'LC_Regroup'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    AnnouncementType = Column(Integer())
    DisclosureMethod = Column(Integer())
    EventContent = Column(String())
    ActionDesc = Column(String())
    NewestAdvance = Column(String())
    EventSubject = Column(Integer())
    EventProcedure = Column(Integer())
    ActionWays = Column(Integer())
    CurrencyUnit = Column(Integer())
    SubjectName = Column(String())
    SubjectCode = Column(Integer())
    SubjectAssociation = Column(Integer())
    ObjectName = Column(String())
    ObjectCode = Column(Integer())
    ObjectAssociation = Column(Integer())
    AgreementDate = Column(String())
    IfEnded = Column(Integer())
    Note = Column(String())
    EventType = Column(Integer())
    AssetBookValue = Column(Double())
    AppraisalValue = Column(Double())
    SaleProceeds = Column(Double())
    TransferIncome = Column(Double())
    BookValueOutAsset = Column(Double())
    AppraisalValueOutAsset = Column(Double())
    RepalcementPriceAssetOut = Column(Double())
    BookValueAssetIn = Column(Double())
    AppraisalValueAssetIn = Column(Double())
    RepalcementPriceAssetIn = Column(Double())
    DebtRearrangementSum = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())
    EventCode = Column(String())
    SerialNumber = Column(Integer())


class LC_MajorContract(Base):
    __tablename__ = 'LC_MajorContract'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    BulletinType = Column(Integer())
    EventContent = Column(String())
    ActionDesc = Column(String())
    NewestAdvance = Column(String())
    EventSubject = Column(Integer())
    EventProcedure = Column(Integer())
    ActionWays = Column(Integer())
    CurrencyUnit = Column(Integer())
    SubjectName = Column(String())
    SubjectCode = Column(Integer())
    SubjectAssociation = Column(Integer())
    ObjectName = Column(String())
    ObjectCode = Column(Integer())
    ObjectAssociation = Column(Integer())
    AgreementDate = Column(String())
    ContractObject = Column(String())
    ContractWay = Column(Integer())
    AcceptanceDate = Column(String())
    AmountInvolved = Column(Double())
    ContractBeginDate = Column(String())
    ContractEndDate = Column(String())
    ContractPeriod = Column(Double())
    ContractEffect = Column(String())
    RemarkDesc = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class LC_InvestorRa(Base):
    __tablename__ = 'LC_InvestorRa'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InfoPublDate = Column(String())
    InnerCode = Column(Integer())
    Nbcode = Column(String())
    ReceptionDate = Column(String())
    ReceptionDaTime = Column(String())
    SerialNb = Column(Integer())
    ActivitiesCate = Column(Integer())
    Participant = Column(String())
    Place = Column(String())
    ListingCreper = Column(String())
    TmainContent = Column(String())
    ArticleFile = Column(String())
    FileType = Column(Integer())
    InfoTitle = Column(String())
    LinkAddress = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    ReceptionDateE = Column(String())


class LC_InvestorDetail(Base):
    __tablename__ = 'LC_InvestorDetail'

    ID = Column(Integer(), primary_key=True, nullable=False)
    RID = Column(Integer())
    Participant = Column(String())
    ParticipantID = Column(Integer())
    PersonalName = Column(String())
    PersonalID = Column(Integer())
    PostName = Column(String())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    SerialNumber = Column(Integer())


class LC_ESOP(Base):
    __tablename__ = 'LC_ESOP'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    IniInfoPublDate = Column(String())
    DMAnnounceDate = Column(String())
    SMAnnounceDate = Column(String())
    Process = Column(Integer())
    SerialNumber = Column(Integer())
    IfPeriod = Column(Integer())
    Period = Column(Integer())
    InitialImpleDay = Column(String())
    ShareSource = Column(String())
    ShareCelling = Column(Double())
    ShareFloor = Column(Double())
    FundCelling = Column(Double())
    FundFloor = Column(Double())
    Duration = Column(Double())
    LockDuration = Column(Double())
    ReleaseDuration = Column(Double())
    FundSource = Column(String())
    Participant = Column(String())
    Management = Column(String())
    ManageInsitute = Column(String())
    PlanName = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    PeriodSituation = Column(String())
    PlanRatio = Column(String())
    StockPrice = Column(Double())
    PartiAmount = Column(Integer())
    ManagementPartiAmount = Column(Integer())
    ManagementShares = Column(Double())
    ManagementRatio = Column(Double())
    EmployeePartiAmount = Column(Integer())
    EmployeeShares = Column(Double())
    EmployeeRatio = Column(Double())
    ImpleEndDate = Column(String())
    LockStartDate = Column(String())
    Statement = Column(String())


class LC_ESOPSummary(Base):
    __tablename__ = 'LC_ESOPSummary'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    IniInfoPublDate = Column(String())
    DMAnnounceDate = Column(String())
    SMAnnounceDate = Column(String())
    Process = Column(Integer())
    SerialNumber = Column(Integer())
    IfPeriod = Column(Integer())
    ShareCelling = Column(Double())
    ShareFloor = Column(Double())
    FundCelling = Column(Double())
    FundFloor = Column(Double())
    Statement = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    PeriodSituation = Column(String())


class LC_TransferPlan(Base):
    __tablename__ = 'LC_TransferPlan'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    PromiseSubject = Column(Integer())
    EventType = Column(Integer())
    IfEffected = Column(Integer())
    SHSN = Column(Integer())
    SHName = Column(String())
    TransferPlanType = Column(Integer())
    PromiseStatment = Column(String())
    IncreaseTime = Column(String())
    IncreaseTerm = Column(Double())
    IncreasePriceStatement = Column(String())
    IncreasePriceCeiling = Column(Double())
    IncreasePriceFloor = Column(Double())
    IncreaseSize = Column(String())
    IncreaseShareCeiling = Column(Double())
    IncreaseShareFloor = Column(Double())
    IncreaseRatioCeiling = Column(Double())
    IncreaseRatioFloor = Column(Double())
    IncreaseFundCeiling = Column(Double())
    IncreaseFundFloor = Column(Double())
    NotReducePromise = Column(Double())
    TradeType = Column(Integer())
    TradeTypeStatment = Column(String())
    ReduceTime = Column(String())
    ReduceTerm = Column(Double())
    ReducePriceStatement = Column(String())
    ReducePriceCeiling = Column(Double())
    ReducePriceFloor = Column(Double())
    ReduceSize = Column(String())
    ReduceShareCeiling = Column(Double())
    ReduceShareFloor = Column(Double())
    ReduceRatioCeiling = Column(Double())
    ReduceRatioFloor = Column(Double())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    PromiseBeginDate = Column(String())
    PromiseEndDate = Column(String())
    EventProcedure = Column(Integer())


class LC_SMAttendInfo(Base):
    __tablename__ = 'LC_SMAttendInfo'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    InitialInfoPublDate = Column(String())
    LatestInfoPublDate = Column(String())
    SMRegDate = Column(String())
    MeetingDate = Column(String())
    AnounceDate = Column(String())
    CancelDate = Column(String())
    Address = Column(String())
    MeetingType = Column(Integer())
    VotingMeans = Column(Integer())
    Year = Column(Integer())
    Series = Column(Integer())
    NetVotingCode = Column(String())
    VotingAbbr = Column(String())
    Presider = Column(String())
    TestmonyLawOffice = Column(String())
    LawOfficeCode = Column(Integer())
    Lawyer = Column(String())
    AttendanceType = Column(Integer())
    AttendanceNumber = Column(Integer())
    ShareReprensented = Column(Double())
    RatioInTotalShare = Column(Double())
    NTSHNumber = Column(Integer())
    ForeignNTSHNumber = Column(Integer())
    NTSHRepresentedShare = Column(Double())
    FNTSHRepresentedShare = Column(Double())
    TSHNumber = Column(Integer())
    ATSHNumber = Column(Integer())
    BTSHNumber = Column(Integer())
    HTSHNumber = Column(Integer())
    OtherTSHNumber = Column(Integer())
    TSHRepresentedShare = Column(Double())
    ATSHRepresentedShare = Column(Double())
    BTSHRepresentedShare = Column(Double())
    HTSHRepresentedShare = Column(Double())
    OtherTSHRepresentedShare = Column(Double())
    XGRQ = Column(String())
    JSID = Column(Integer())
    IfEffected = Column(Integer())
    ASharesNumber = Column(Integer())
    HSharesNumber = Column(Integer())
    OtherSharesNumber = Column(Integer())
    ASharesReprensented = Column(Double())
    HSharesReprensented = Column(Double())
    OSharesReprensented = Column(Double())
    ASharesRatio = Column(Double())
    HSharesRatio = Column(Double())
    OtherSharesRatio = Column(Double())
    MSharesNumber = Column(Integer())
    MShareReprensented = Column(Double())
    MSharesRatio = Column(Double())
    PSharesNumber = Column(Integer())
    PSharesReprensented = Column(Double())
    PSharesRatio = Column(Double())
    InsertTime = Column(String())
    SHMeetingTime = Column(String())
    ShareANumber = Column(Integer())
    ShareBNumber = Column(Integer())
    ShareAReprensented = Column(Double())
    ShareBReprensented = Column(Double())
    ShareARatio = Column(Double())
    ShareBRatio = Column(Double())
    MeetingRegStartDate = Column(String())
    MeetingRegEndDate = Column(String())
    NetVotingStartDate = Column(String())
    NetVotingEndDate = Column(String())
    ProposalContent = Column(String())
    NetVotingPlatform = Column(Integer())
    SerialNumber = Column(Integer())


class HK_EmployeeChange(Base):
    __tablename__ = 'HK_EmployeeChange'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(Integer())
    SMAnnounceDate = Column(String())
    IfEffected = Column(Integer())
    EffectiveDate = Column(String())
    QuaBeforeChange = Column(Double())
    QuaAfterChange = Column(Double())
    ExpiryDate = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class HK_StockArchives(Base):
    __tablename__ = 'HK_StockArchives'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EstablishmentDate = Column(String())
    RegAbbr = Column(Integer())
    Business = Column(String())
    InduCHKE = Column(Integer())
    InduCHS = Column(Integer())
    Chairman = Column(String())
    CompanySecretary = Column(String())
    CertifiedAccountant = Column(String())
    RegisteredOffice = Column(String())
    GeneralOffice = Column(String())
    Registrars = Column(String())
    Tel = Column(String())
    Fax = Column(String())
    Eail = Column(String())
    Website = Column(String())
    BriefIntroduction = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    CompanyType = Column(Integer())
    CompanyTypeDesc = Column(String())
    ChiName = Column(String())
    AuditInstitution = Column(String())
    RegCapital = Column(Double())
    RegCapitalCurrency = Column(Integer())


class CS_HKStockPerformance(Base):
    __tablename__ = 'CS_HKStockPerformance'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    TradingDay = Column(String())
    PrevClosePrice = Column(Double())
    OpenPrice = Column(Double())
    HighPrice = Column(Double())
    LowPrice = Column(Double())
    ClosePrice = Column(Double())
    CurrencyUnitCode = Column(Integer())
    TurnoverVolume = Column(Double())
    TurnoverValue = Column(Double())
    ChangeOF = Column(Double())
    ChangePCT = Column(Double())
    RangePCT = Column(Double())
    TurnoverRate = Column(Double())
    AvgPrice = Column(Double())
    TotalMV = Column(Double())
    NegotiableMV = Column(Double())
    TurnoverValueRW = Column(Double())
    TurnoverVolumeRW = Column(Double())
    ChangeOFRW = Column(Double())
    ChangePCTRW = Column(Double())
    RangePCTRW = Column(Double())
    TurnoverRateRW = Column(Double())
    AvgPriceRW = Column(Double())
    HighPriceRW = Column(Double())
    LowPriceRW = Column(Double())
    HighestClosePriceRW = Column(Double())
    LowestClosePriceRW = Column(Double())
    TurnoverValuePerDayRW = Column(Double())
    TurnoverRatePerDayRW = Column(Double())
    TurnVolumePerDayRW = Column(Double())
    ChangePCTPerDayRW = Column(Double())
    RangePCTPerDayRW = Column(Double())
    TotalMVPerDayRW = Column(Double())
    NegotiableMVPerDayRW = Column(Double())
    TurnoverValueTW = Column(Double())
    TurnoverVolumeTW = Column(Double())
    ChangeOFTW = Column(Double())
    ChangePCTTW = Column(Double())
    RangePCTTW = Column(Double())
    TurnoverRateTW = Column(Double())
    AvgPriceTW = Column(Double())
    HighPriceTW = Column(Double())
    LowPriceTW = Column(Double())
    HighestClosePriceTW = Column(Double())
    LowestClosePriceTW = Column(Double())
    TurnoverValuePerDayTW = Column(Double())
    TurnoverRatePerDayTW = Column(Double())
    TurnVolumePerDayTW = Column(Double())
    ChangePCTPerDayTW = Column(Double())
    RangePCTPerDayTW = Column(Double())
    TotalMVPerDayTW = Column(Double())
    NegotiableMVPerDayTW = Column(Double())
    TurnoverValueRM = Column(Double())
    TurnoverVolumeRM = Column(Double())
    ChangeOFRM = Column(Double())
    ChangePCTRM = Column(Double())
    RangePCTRM = Column(Double())
    TurnoverRateRM = Column(Double())
    AvgPriceRM = Column(Double())
    HighPriceRM = Column(Double())
    LowPriceRM = Column(Double())
    HighestClosePriceRM = Column(Double())
    LowestClosePriceRM = Column(Double())
    TurnoverValuePerDayRM = Column(Double())
    TurnoverRatePerDayRM = Column(Double())
    TurnVolumePerDayRM = Column(Double())
    ChangePCTPerDayRM = Column(Double())
    RangePCTPerDayRM = Column(Double())
    TotalMVPerDayRM = Column(Double())
    NegotiableMVPerDayRM = Column(Double())
    TurnoverValueTM = Column(Double())
    TurnoverVolumeTM = Column(Double())
    ChangeOFTM = Column(Double())
    ChangePCTTM = Column(Double())
    RangePCTTM = Column(Double())
    TurnoverRateTM = Column(Double())
    AvgPriceTM = Column(Double())
    HighPriceTM = Column(Double())
    LowPriceTM = Column(Double())
    HighestClosePriceTM = Column(Double())
    LowestClosePriceTM = Column(Double())
    TurnoverValuePerDayTM = Column(Double())
    TurnoverRatePerDayTM = Column(Double())
    TurnVolumePerDayTM = Column(Double())
    ChangePCTPerDayTM = Column(Double())
    RangePCTPerDayTM = Column(Double())
    TotalMVPerDayTM = Column(Double())
    NegotiableMVPerDayTM = Column(Double())
    TurnoverValueRMThree = Column(Double())
    TurnoverVolumeRMThree = Column(Double())
    ChangeOFRMThree = Column(Double())
    ChangePCTRMThree = Column(Double())
    RangePCTRMThree = Column(Double())
    TurnoverRateRMThree = Column(Double())
    AvgPriceRMThree = Column(Double())
    HighPriceRMThree = Column(Double())
    LowPriceRMThree = Column(Double())
    HighestClosePRMThree = Column(Double())
    LowestClosePRMThree = Column(Double())
    TurnValuePDayRMThree = Column(Double())
    TurnRatePDayRMThree = Column(Double())
    TurnVolumePDayRMThree = Column(Double())
    ChangePCTPDayRMThree = Column(Double())
    RangePCTPDayRMThree = Column(Double())
    TotalMVPerDayRMThree = Column(Double())
    NegotiableMVPRMThree = Column(Double())
    TurnoverValueRMSix = Column(Double())
    TurnoverVolumeRMSix = Column(Double())
    ChangeOFRMSix = Column(Double())
    ChangePCTRMSix = Column(Double())
    RangePCTRMSix = Column(Double())
    TurnoverRateRMSix = Column(Double())
    AvgPriceRMSix = Column(Double())
    HighPriceRMSix = Column(Double())
    LowPriceRMSix = Column(Double())
    HighestClosePRMSix = Column(Double())
    LowestClosePRMSix = Column(Double())
    TurnValuePDayRMSix = Column(Double())
    TurnRatePDayRMSix = Column(Double())
    TurnVolumePDayRMSix = Column(Double())
    ChangePCTPDayRMSix = Column(Double())
    RangePCTPDayRMSix = Column(Double())
    TotalMVPerDayRMSix = Column(Double())
    NegotiableMVPRMSix = Column(Double())
    TurnoverValueRY = Column(Double())
    TurnoverVolumeRY = Column(Double())
    ChangeOFRY = Column(Double())
    ChangePCTRY = Column(Double())
    RangePCTRY = Column(Double())
    TurnoverRateRY = Column(Double())
    AvgPriceRY = Column(Double())
    HighPriceRY = Column(Double())
    LowPriceRY = Column(Double())
    HighestClosePRY = Column(Double())
    LowestClosePRY = Column(Double())
    TurnoverValuePDayRY = Column(Double())
    TurnoverRatePDayRY = Column(Double())
    TurnVolumePDayRY = Column(Double())
    ChangePCTPDayRY = Column(Double())
    RangePCTPDayRY = Column(Double())
    TotalMVPerDayRY = Column(Double())
    NegotiableMVPRY = Column(Double())
    TurnoverValueYTD = Column(Double())
    TurnoverVolumeYTD = Column(Double())
    ChangeOFYTD = Column(Double())
    ChangePCTYTD = Column(Double())
    RangePCTYTD = Column(Double())
    TurnoverRateYTD = Column(Double())
    AvgPriceYTD = Column(Double())
    HighPriceYTD = Column(Double())
    LowPriceYTD = Column(Double())
    HighestClosePriceYTD = Column(Double())
    LowestClosePriceYTD = Column(Double())
    TurnoverValuePerDayYTD = Column(Double())
    TurnoverRatePerDayYTD = Column(Double())
    TurnVolumePDayYTD = Column(Double())
    ChangePCTPerDayYTD = Column(Double())
    RangePCTPerDayYTD = Column(Double())
    TotalMVPerDayYTD = Column(Double())
    NegotiableMVPYTD = Column(Double())
    HighAdjustedPrice = Column(Double())
    HighAdjustedPriceDate = Column(String())
    LowAdjustedPrice = Column(Double())
    LowAdjustedPriceDate = Column(String())
    UpdateTime = Column(String())
    InsertTime = Column(String())
    JSID = Column(Integer())


class US_CompanyInfo(Base):
    __tablename__ = 'US_CompanyInfo'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    EngName = Column(String())
    EngNameAbbr = Column(String())
    ChiName = Column(String())
    PEOAddress = Column(String())
    PEOCity = Column(String())
    PEOState = Column(String())
    PEOZip = Column(String())
    PEOStatus = Column(String())
    PEOTel = Column(String())
    BusinessDcrp = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    BriefIntroText = Column(String())
    EstablishmentDate = Column(String())
    CompanyType = Column(Integer())
    BriefIntroTextEng = Column(String())
    Fax = Column(String())
    RegCountry = Column(Integer())
    RegState = Column(String())
    BusinessDcrpEng = Column(String())
    IfHeadOffice = Column(Integer())
    LinkAddress = Column(String())
    CountryCode = Column(Integer())
    EstablishmentDatePreci = Column(Integer())
    InsertTime = Column(String())


class US_DailyQuote(Base):
    __tablename__ = 'US_DailyQuote'

    ID = Column(Integer(), primary_key=True, nullable=False)
    TradingDay = Column(String())
    InnerCode = Column(Integer())
    Open = Column(Double())
    High = Column(Double())
    Low = Column(Double())
    Close = Column(Double())
    Volume = Column(Double())
    EPSTTM = Column(Double())
    MarketCap = Column(Double())
    ShareOST = Column(Double())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    PrevClosePrice = Column(Double())
    ChangePCT = Column(Double())
    AvgPrice = Column(Double())
    TurnoverValue = Column(Double())
    ChangeOF = Column(Double())


class MF_FundArchives(Base):
    __tablename__ = 'MF_FundArchives'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    EstablishmentDate = Column(String())
    ListedDate = Column(String())
    Duration = Column(Double())
    StartDate = Column(String())
    ExpireDate = Column(String())
    Manager = Column(String())
    InvestAdvisorCode = Column(Integer())
    TrusteeCode = Column(Integer())
    Warrantor = Column(String())
    Type = Column(Integer())
    InvestmentType = Column(Integer())
    InvestStyle = Column(Integer())
    FoundedSize = Column(Double())
    InvestOrientation = Column(String())
    InvestTarget = Column(String())
    PerformanceBenchMark = Column(String())
    ProfitDistributionRule = Column(String())
    InvestField = Column(String())
    BriefIntro = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    ApplyingCodeFront = Column(String())
    ApplyingCodeBack = Column(String())
    GuaranteedPeriod = Column(Double())
    RiskReturncharacter = Column(String())
    LowestSumSubscribing = Column(String())
    LowestSumRedemption = Column(Double())
    LSFRDescription = Column(String())
    LowestSumForHolding = Column(Double())
    LSFHDescription = Column(String())
    FundNature = Column(Integer())
    FundTypeCode = Column(Integer())
    FundType = Column(String())
    CarryOverDate = Column(Integer())
    CarryOverDateRemark = Column(String())
    CarryOverType = Column(Integer())
    RegInstCode = Column(Integer())
    SecurityCode = Column(String())
    DeliveryDays = Column(Integer())
    RiskReturnCode = Column(Integer())
    FloatType = Column(Integer())
    CustodyMarket = Column(Integer())
    OperationPeriod = Column(Double())
    OperationPDUnitCode = Column(Integer())
    OperationPDUnitName = Column(String())
    IfInitiatingFund = Column(Integer())
    ClassificationFundType = Column(Integer())
    AgrBenchmkRateOfShareA = Column(String())
    AgrBenchmkRateOfShareANotes = Column(String())
    RegularShareConversionNotes = Column(String())
    NonRegularShareConversionNotes = Column(String())
    ExApplyingMarket = Column(Integer())
    ExApplyingCode = Column(String())
    ExApplyingAbbr = Column(String())
    ShareProperties = Column(Integer())
    StClearingDate = Column(String())
    EnClearingDate = Column(String())
    LowestSumSubLL = Column(Double())
    LowestSumPurLL = Column(Double())
    MainCode = Column(String())
    ExProfitDistri = Column(Integer())
    OTCProfitDistri = Column(Integer())
    IfFOF = Column(Integer())
    IfPensionTarget = Column(Integer())
    PRconfirmationdate = Column(Integer())
    EstablishmentDateII = Column(String())
    InsertTime = Column(String())
    TransCode = Column(Integer())
    LargeRedemptionRatio = Column(Double())
    LastOperationDate = Column(String())
    SecuCode = Column(String())


class MF_FundProdName(Base):
    __tablename__ = 'MF_FundProdName'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    InfoType = Column(Integer())
    DisclName = Column(String())
    EffectiveDate = Column(String())
    ExpiryDate = Column(String())
    IfEffected = Column(Integer())
    Remark = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    ChiSpelling = Column(String())
    TransCode = Column(Integer())
    InsertTime = Column(String())


class MF_InvestAdvisorOutline(Base):
    __tablename__ = 'MF_InvestAdvisorOutline'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InvestAdvisorCode = Column(Integer())
    InvestAdvisorName = Column(String())
    InvestAdvisorAbbrName = Column(String())
    LegalRepr = Column(String())
    GeneralManager = Column(String())
    EstablishmentDate = Column(String())
    OrganizationForm = Column(String())
    RegCapital = Column(Double())
    RegAddr = Column(String())
    OfficeAddr = Column(String())
    ZipCode = Column(String())
    Email = Column(String())
    ContactAddr = Column(String())
    Tel = Column(String())
    Fax = Column(String())
    WebSite = Column(String())
    LinkMan = Column(String())
    Background = Column(String())
    Region = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    ServiceLine = Column(String())
    MaturityEndDate = Column(String())
    TACode = Column(String())
    CSRCCode = Column(String())


class MF_Dividend(Base):
    __tablename__ = 'MF_Dividend'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    InfoPublDate = Column(String())
    InfoSource = Column(String())
    EndDate = Column(String())
    UnitProfit = Column(Double())
    UnitRetainedProfit = Column(Double())
    IfDistributed = Column(Integer())
    DividendRatioBeforeTax = Column(Double())
    ActualRatioAfterTax = Column(Double())
    Dividendsum = Column(Double())
    ReDate = Column(String())
    ExRightDate = Column(String())
    ExecuteDate = Column(String())
    SchemeModification = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    ReinvestDay = Column(String())
    AccountDay = Column(String())
    RedemptionDay = Column(String())
    UnitProfitYTD = Column(Double())
    DividendSumYTD = Column(Double())
    DividendTimesYTD = Column(Integer())
    DiviSumSinceInception = Column(Double())
    DiviTimesSinceIncepion = Column(Integer())
    EventProcedureCode = Column(Integer())
    EventProcedure = Column(String())
    ExRightDateEX = Column(String())
    ExRightDateCurbEX = Column(String())
    ExecuteDateEX = Column(String())
    ExecuteDateCurbEX = Column(String())
    DistributableProfits = Column(Double())
    AllocationValue = Column(Double())
    ProfitDistDate = Column(String())
    DistributedRange = Column(String())
    TransCode = Column(Integer())
    DividendImplementDate = Column(String())


class LC_ViolatiParty(Base):
    __tablename__ = 'LC_ViolatiParty'

    ID = Column(Integer(), primary_key=True, nullable=False)
    RID = Column(Integer())
    EventCode = Column(Integer())
    PartyName = Column(String())
    PartyType = Column(Integer())
    PartyCode = Column(Integer())
    BeginDate = Column(String())
    EndDate = Column(String())
    ViolationClause = Column(String())
    PenalOrg = Column(Integer())
    PenalType = Column(Integer())
    AmountInvolved = Column(Double())
    CurrencyCode = Column(Integer())
    PenalStatement = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    PenalOrgCode = Column(Integer())
    RelataCompany = Column(Integer())
    PenalTypeNew = Column(Integer())
    ViolationStatement = Column(String())
    InsertTime = Column(String())
    AnnID = Column(Integer())


class LC_IndexBasicInfo(Base):
    __tablename__ = 'LC_IndexBasicInfo'

    ID = Column(Integer(), primary_key=True, nullable=False)
    IndexCode = Column(Integer())
    IndexType = Column(Integer())
    ComponentType = Column(Integer())
    IndustryStandard = Column(Integer())
    IndustryType = Column(Integer())
    PubOrgCode = Column(Integer())
    PubOrgName = Column(String())
    CreatIndexOrgCode = Column(Integer())
    CreatIndexOrgName = Column(String())
    PubDate = Column(String())
    BaseDate = Column(String())
    BasePoint = Column(Double())
    WAMethod = Column(Integer())
    ComponentSum = Column(Integer())
    ComponentAdPeriod = Column(Integer())
    IndexRemark = Column(String())
    EndDate = Column(String())
    XGRQ = Column(String())
    JSID = Column(Integer())
    IndexPriceType = Column(Integer())
    IndexDesignType = Column(Integer())
    Relationship = Column(Integer())
    RelaMainIndexCode = Column(String())
    SecuMarket = Column(Integer())
    CurrencyCode = Column(Integer())
    IndexAbstract = Column(String())
    RelaMainCode = Column(Integer())
    PubIndexType = Column(Integer())
    IndexSeries = Column(Integer())


class LC_IndexComponent(Base):
    __tablename__ = 'LC_IndexComponent'

    ID = Column(Integer(), primary_key=True, nullable=False)
    IndexInnerCode = Column(Integer())
    SecuInnerCode = Column(Integer())
    InDate = Column(String())
    OutDate = Column(String())
    Flag = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    SecuMarket = Column(Integer())


class LC_InstiArchive(Base):
    __tablename__ = 'LC_InstiArchive'

    ID = Column(Integer(), primary_key=True, nullable=False)
    CompanyCode = Column(Integer())
    ParentCompany = Column(Integer())
    ListedCode = Column(Integer())
    InvestAdvisorName = Column(Integer())
    TrusteeName = Column(Integer())
    ChiName = Column(String())
    AbbrChiName = Column(String())
    NameChiSpelling = Column(String())
    EngName = Column(String())
    AbbrEngName = Column(String())
    RegCapital = Column(Double())
    CurrencyUnit = Column(Integer())
    EstablishmentDate = Column(String())
    EconomicNature = Column(Integer())
    CompanyNature = Column(Integer())
    CompanyType = Column(Integer())
    RegAddr = Column(String())
    RegZip = Column(String())
    RegCity = Column(Integer())
    OfficeAddr = Column(String())
    ContactAddr = Column(String())
    ContactZip = Column(String())
    ContactCity = Column(Integer())
    Email = Column(String())
    Website = Column(String())
    LegalPersonRepr = Column(String())
    GeneralManager = Column(String())
    OtherManager = Column(String())
    Contactman = Column(String())
    Tel = Column(String())
    Fax = Column(String())
    BriefIntroText = Column(String())
    BusinessMajor = Column(String())
    Industry = Column(Integer())
    StartDate = Column(String())
    CloseDate = Column(String())
    CloseReason = Column(Integer())
    IfExisted = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    OrganizationCode = Column(String())
    CompanyCval = Column(Integer())
    CreditCode = Column(String())
    RegArea = Column(Integer())
    RegOrg = Column(String())
    RegStatus = Column(Integer())


class SecuMain(Base):
    __tablename__ = 'SecuMain'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    SecuCode = Column(String())
    ChiName = Column(String())
    ChiNameAbbr = Column(String())
    EngName = Column(String())
    EngNameAbbr = Column(String())
    SecuAbbr = Column(String())
    ChiSpelling = Column(String())
    SecuMarket = Column(Integer())
    SecuCategory = Column(Integer())
    ListedDate = Column(String())
    ListedSector = Column(Integer())
    ListedState = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    ISIN = Column(String())
    ExtendedAbbr = Column(String())
    ExtendedSpelling = Column(String())


class HK_SecuMain(Base):
    __tablename__ = 'HK_SecuMain'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    SecuCode = Column(String())
    ChiName = Column(String())
    ChiNameAbbr = Column(String())
    EngName = Column(String())
    EngNameAbbr = Column(String())
    SecuAbbr = Column(String())
    ChiSpelling = Column(String())
    SecuMarket = Column(Integer())
    SecuCategory = Column(Integer())
    ListedDate = Column(String())
    ListedSector = Column(Integer())
    ListedState = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    DelistingDate = Column(String())
    ISIN = Column(String())
    FormerName = Column(String())
    TradingUnit = Column(Double())
    TraCurrUnit = Column(Integer())
    InsertTime = Column(String())


class CT_SystemConst(Base):
    __tablename__ = 'CT_SystemConst'

    ID = Column(Integer(), primary_key=True, nullable=False)
    LB = Column(Integer())
    LBMC = Column(String())
    MS = Column(String())
    DM = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())
    FVALUE = Column(Double())
    IVALUE = Column(Integer())
    DVALUE = Column(String())
    CVALUE = Column(String())


class QT_TradingDayNew(Base):
    __tablename__ = 'QT_TradingDayNew'

    ID = Column(Integer(), primary_key=True, nullable=False)
    TradingDate = Column(String())
    IfTradingDay = Column(Integer())
    SecuMarket = Column(Integer())
    IfWeekEnd = Column(Integer())
    IfMonthEnd = Column(Integer())
    IfQuarterEnd = Column(Integer())
    IfYearEnd = Column(Integer())
    XGRQ = Column(String())
    JSID = Column(Integer())


class LC_AreaCode(Base):
    __tablename__ = 'LC_AreaCode'

    ID = Column(Integer(), primary_key=True, nullable=False)
    AreaInnerCode = Column(Integer())
    AreaCode = Column(String())
    FirstLevelCode = Column(Integer())
    SecondLevelCode = Column(Integer())
    AreaChiName = Column(String())
    AreaEngName = Column(String())
    AreaEngNameAbbr = Column(String())
    ParentNode = Column(Integer())
    ParentName = Column(String())
    IfEffected = Column(Integer())
    CancelDate = Column(String())
    ChangeNote = Column(String())
    Remark = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    InsertTime = Column(String())


class PS_EventStru(Base):
    __tablename__ = 'PS_EventStru'

    ID = Column(Integer(), primary_key=True, nullable=False)
    EventName = Column(String())
    EventCode = Column(String())
    FEventCode = Column(String())
    EventLevel = Column(Integer())
    IfEffected = Column(String())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())


class US_SecuMain(Base):
    __tablename__ = 'US_SecuMain'

    ID = Column(Integer(), primary_key=True, nullable=False)
    InnerCode = Column(Integer())
    SecuCode = Column(String())
    SecuAbbr = Column(String())
    ChiSpelling = Column(String())
    SecuCategory = Column(Integer())
    SecuMarket = Column(Integer())
    ListedSector = Column(Integer())
    ListedDate = Column(String())
    ListedState = Column(Integer())
    ISIN = Column(String())
    CompanyCode = Column(Integer())
    UpdateTime = Column(String())
    JSID = Column(Integer())
    DelistingDate = Column(String())
    InsertTime = Column(String())
    EngName = Column(String())
    ChiName = Column(String())


class PS_NewsSecurity(Base):
    __tablename__ = 'PS_NewsSecurity'

    ID = Column(Integer(), primary_key=True, nullable=False)
    RID = Column(Integer())
    InnerCode = Column(Integer())
    CompanyCode = Column(Integer())
    EventType = Column(String())
    EventName = Column(String())
    EventDate = Column(String())
    EmotionDirection = Column(String())
    EmotionImportance = Column(String())
    InsertTime = Column(String())
    UpdateTime = Column(String())
    JSID = Column(Integer())
